MSDE->ACCESS ERROR
From: Dave (dbg_at_012.net.il)
Date: 11/14/04
- Next message: Hari Prasad: "Re: msde from sql server"
- Previous message: Dave: "msde from sql server"
- Next in thread: Greg Low [MVP]: "Re: MSDE->ACCESS ERROR"
- Reply: Greg Low [MVP]: "Re: MSDE->ACCESS ERROR"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 14 Nov 2004 21:41:45 +0200
I am using MSDE on XP pro Service Pack 2 and have stored my data on the
default instance of MSSQLSERVER on my computer ID OFFICEPC. This is
networked to LAPTOP and SHOPPC.
My Access front end works fine with the SQL back end on the OFFICEPC. But
when I try to link the same front end from one of the other computers using
ODBC, i get the following error:
Connection Failed:
SQL state 2800
SQL Server Error 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'OFFICEPC\Guest'
I have run svrnetcn.exe and enabled port 1433 to pass through the firewall.
Ports 135 and 445 are also enabled.
What have I done wrong? Thanks in advance for any help
hi Gerald,
"Gerald G" <GeraldG@discussions.microsoft.com> ha scritto nel messaggio
news:54F59F97-F083-4C93-B08A-4FCEA3429731@microsoft.com
> I am using MSDE on XP pro Service Pack 2 and have stored my data on
> the default instance of MSSQLSERVER on my computer ID OFFICEPC. This
> is networked to LAPTOP and SHOPPC.
>
> My Access front end works fine with the SQL back end on the OFFICEPC.
> But when I try to link the same front end from one of the other
> computers using ODBC, i get the following error:
> Connection Failed:
> SQL state 2800
> SQL Server Error 18456
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> 'OFFICEPC\Guest'
>
> I have run svrnetcn.exe and enabled port 1433 to pass through the
> firewall. Ports 135 and 445 are also enabled.
>
> What have I done wrong? Thanks in advance for any help
it seems you do not have firewall troubles, but standard security problems,
as OFFICEPC\.. users are not granted login to MSDE instance... please verify
your Logins
can you telnet on port 1433 the MSDE instance?
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply Hi Andrea - thanks for answering I think you are right about it being a standard security problem. How do I telnet on port 1433, and How do I grant login to my MSDE instance? "Andrea Montanari" wrote: > hi Gerald, > "Gerald G" <GeraldG@discussions.microsoft.com> ha scritto nel messaggio > news:54F59F97-F083-4C93-B08A-4FCEA3429731@microsoft.com > > I am using MSDE on XP pro Service Pack 2 and have stored my data on > > the default instance of MSSQLSERVER on my computer ID OFFICEPC. This > > is networked to LAPTOP and SHOPPC. > > > > My Access front end works fine with the SQL back end on the OFFICEPC. > > But when I try to link the same front end from one of the other > > computers using ODBC, i get the following error: > > Connection Failed: > > SQL state 2800 > > SQL Server Error 18456 > > [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user > > 'OFFICEPC\Guest' > > > > I have run svrnetcn.exe and enabled port 1433 to pass through the > > firewall. Ports 135 and 445 are also enabled. > > > > What have I done wrong? Thanks in advance for any help > > it seems you do not have firewall troubles, but standard security problems, > as OFFICEPC\.. users are not granted login to MSDE instance... please verify > your Logins > can you telnet on port 1433 the MSDE instance? > -- > Andrea Montanari (Microsoft MVP - SQL Server) > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual > interface) > --------- remove DMO to reply > >hi Gerald "Gerald G" <GeraldG@discussions.microsoft.com> ha scritto nel messaggio news:7CD6EC0F-53A4-4252-9228-A40089BE66FF@microsoft.com > Hi Andrea - thanks for answering > I think you are right about it being a standard security problem. > How do I telnet on port 1433, and How do I grant login to my MSDE > instance? > in order to grant your 'OFFICEPC\xxxx' users, you have to add them to the SQL Server Windows logins... please have a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003#8 for further info about granting login to Windows logins/groups -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Hari Prasad: "Re: msde from sql server"
- Previous message: Dave: "msde from sql server"
- Next in thread: Greg Low [MVP]: "Re: MSDE->ACCESS ERROR"
- Reply: Greg Low [MVP]: "Re: MSDE->ACCESS ERROR"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
