|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Sql Server does not exist or access denied errorI installed sql server 2000 developer edition (SP2) on Windows NT 5.2. This machine (SQL01) is on the same network. When I use enterprise manager on my desktop and try to add new sql server registration, I dont see SQL01 on the list of available servers. When I try to add it, I get an error. Sql Server does not exist or access denied error When I try to connect to sql01 using sql query analyzer and login as sa using sql server authentication, I get an error again Sql Server does not exist or access denied error I dont think its the firewall Can somebody help.... Thanks, Amudha -- zombie Try pinging it first, can you add it iff you use the IP
http://sqlservercode.blogspot.com/ Show quote "zombie" wrote: > Hi, > > I installed sql server 2000 developer edition (SP2) on Windows NT 5.2. > This machine (SQL01) is on the same network. When I use enterprise manager on my > desktop and try to add new sql server registration, I dont see SQL01 on the list > of available servers. When I try to add it, I get an error. > > Sql Server does not exist or access denied error > > When I try to connect to sql01 using sql query analyzer and login as sa using > sql server authentication, I get an error again > > Sql Server does not exist or access denied error > > I dont think its the firewall > > Can somebody help.... > > Thanks, > Amudha > > > -- > zombie > I am able to ping. But I get the same error when I try to add using IP.
Thanks for your reply In article <5799C40E-BC2C-4725-9070-9ABDECCB6***@microsoft.com>, =?Utf-8?B?U1FM?= says... Show quote > >Try pinging it first, can you add it iff you use the IP > >http://sqlservercode.blogspot.com/ > > >"zombie" wrote: > >> Hi, >> >> I installed sql server 2000 developer edition (SP2) on Windows NT 5.2. >>This machine (SQL01) is on the same network. When I use enterprise manager on my >>desktop and try to add new sql server registration, I dont see SQL01 on the list >> of available servers. When I try to add it, I get an error. >> >> Sql Server does not exist or access denied error >> >> When I try to connect to sql01 using sql query analyzer and login as sa using >> sql server authentication, I get an error again >> >> Sql Server does not exist or access denied error >> >> I dont think its the firewall >> >> Can somebody help.... >> >> Thanks, >> Amudha >> >> >> -- >> zombie >> -- zombie Ok, figured it. I installed servicepack 3 and it helped!!!
In article <137405463.0000bb50.042.0***@drn.newsguy.com>, zombie says... Show quote > >Hi, > >I installed sql server 2000 developer edition (SP2) on Windows NT 5.2. >This machine (SQL01) is on the same network. When I use enterprise manager on my >desktop and try to add new sql server registration, I dont see SQL01 on the list >of available servers. When I try to add it, I get an error. > >Sql Server does not exist or access denied error > >When I try to connect to sql01 using sql query analyzer and login as sa using >sql server authentication, I get an error again > >Sql Server does not exist or access denied error > >I dont think its the firewall > >Can somebody help.... > >Thanks, >Amudha > > -- zombie  |
|||||||||||||||||||||||
Other interesting topics