Cant see SQL Server with Client ODBC

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Cant see SQL Server with Client ODBC

Author

Topic

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2010-08-18 : 07:27:38

I have installed SQL Server 2008 on Windows Server 2003 OS and when I go to the client machine and try to access via an ODBC Driver I can not see any of the SQL Server 2008or any of its databases.

I have on the server checked the SQL Server Browser is running.
Shared Memory = Enabled
TCP/IP = Enabled
SQL Server is running

I have with cmdprompt run OSQL -L and I cannot see the MS Server intance which I belive to be MSSQLServer that I checked in services where it is Started.

Any ideas?
HelpMePlease

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-18 : 08:26:12

is the instance hidden?
does the login your using have the permissions on all of the databases?

--------------------
keeping it simple...

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2010-08-18 : 08:54:53

Hi Jen,

Your going to have to help me out here.
The instance is not hidden.
And, the client should have permissions. I am using Windows Authentication.

I also have SQL Server 2005 installed and have db's on this that I can see using the ODBC connection.

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2010-08-18 : 09:29:53

Here is the error message I get on the ODBC: This bearing in mind I run the test against the Default database as no databases are showing

Microsoft SQL Server Native Client Version 10.00.1600

Running connectivity tests...

Attempting connection
[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: The target principal name is incorrect.

[Microsoft][SQL Server Native Client 10.0]Cannot generate SSPI context

TESTS FAILED!

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-18 : 10:06:00

the message says, target principal name is not correct...
have you tried the ip address?

to be clear...you are trying to connect from the sql server machine (local) to connect to the sql server instance?

--------------------
keeping it simple...

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2010-08-18 : 10:20:05

This is a networked PC not the machine the SQL Server is sitting on.
Although I have just tried it on the server machine and found I have the same problem

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-18 : 15:49:54

you have 2005 on the same server? which means either your 2005 is the default and 2008 would be a named instance...or the other way around

in which case, check if you have windows firewall running

did you try the ip address? check if your sql instance is in the dns...try to ping it from your client pc

--------------------
keeping it simple...

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2010-09-06 : 07:22:00

There is no windows firewall running.

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2010-09-08 : 15:33:13

I have with cmdprompt run OSQL -L and I cannot see the MS Server intance which I beleive to be MSSQLServer that I checked in services where it is Started.

There is no firewall on the server as this is internal.
How do I check if the sql instance is in the dns?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources