Data source ODBC - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Data source ODBC

Author

Topic

haroon58
Starting Member

8 Posts

Posted - 2007-12-08 : 20:18:58

Hi all,

I am new to SQL Server. I have some basic questions.

I have installed SQL Server Developer Edition on a Windows XP Media center edition. The installation is successful. Now I am trying to create an ODBC, but I there are some options which I am not quite sure about.

e.g.

1. How SQL Server verify the authenticity of the login ID?
A. Windows NT....
B. SQL Server....

Client Configuration:
Server alias: ???
Named Pipes: What should be the values of [pipe name]?

or should i choose other options?....

And I when I use Query Analyzer to connect to Server, the authentication fails..

Can some one point me to the right direction, or if there's some documentation on this subject, that would be very much appreciated.

Thanks in advance.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2007-12-08 : 20:31:28

1.You would use windows authentication if you want users to connect to the server using their windows login credentials by default. SQL server authentication is where you create user ids and passwords and those are used to login to the server, regardless of the windows sign on creds.

In the SQL server you would need to have all of those windows ID's set up as users and grant the necessary permissions. Set up a user id / password and set up the ODBC with the SQL server authentication.

The other questions can only be answered by you since you set up the server...what is the server name.

In our case that server name IS the alias, rather than using the IP address.

Poor planning on your part does not constitute an emergency on my part.

haroon58
Starting Member

8 Posts

Posted - 2007-12-08 : 21:04:28

thanks for quick revert.

I'm using the proper values, i think. I am using the name of the database for [server alias] , [server name] and [pipe name]. when i select the option "Connect to SQL Server to obtain default setting for the additional configuraion options" then i get the follwoing error.


Microsoft SQL Server ODBC Driver Version 03.85.1117

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.

TESTS FAILED!

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2007-12-08 : 21:07:06

make sure that the login creds you are using to test have been granted access to the server.

Poor planning on your part does not constitute an emergency on my part.

haroon58
Starting Member

8 Posts

Posted - 2007-12-08 : 21:26:27

Hi,

This might sound very silly question, but how can I verify if the login credential if permission is granted to access SQL server.

I verified, the administrator account of my windows machine is indeed present in SQL Server, with [dbo]. can you tell me how to verify permission for that?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-08 : 21:27:49

Did you enable named pipes protocol on sql server in surface area configuration?

haroon58
Starting Member

8 Posts

Posted - 2007-12-08 : 21:32:52

I might sound very silly, how can i verify that...

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-08 : 22:01:36

Check it in sql server surface area configuration.

haroon58
Starting Member

8 Posts

Posted - 2007-12-08 : 22:29:11

quote:
Originally posted by rmiao

Check it in sql server surface area configuration.

I am using SQL Server Developer edition. The only products that were installed, are:

1. Client Network Utility
2. Server Netwrok Utility
3. Enterprise Manager
4. Query Analyzer
5. Congifure SQL XML Support in IIS.
6. Import and Export Data
7. Profiler
8. Server Manager.

I don't seem to find Surface area configuration.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-08 : 23:18:14

Ok, you have sql2k. Check it in server network utility.

haroon58
Starting Member

8 Posts

Posted - 2007-12-08 : 23:47:13

quote:
Originally posted by rmiao

Ok, you have sql2k. Check it in server network utility.

Thanks alot for that. It did the trick.

Now I have another issue. I need to make my SQL Server instance case-sensitive. Can I do it, after the installation, or it has to be done during the installation? can you comment on this please.

Thanks.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-12-09 : 00:01:20

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46915

elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources