June 23, 2003 at 3:12 pm
When creating a New Data Source to SQL Server, via the ODBC Data Source Admin utility, I am trying to understand what information gets entered into the "Server" field. Is this the name of the physical server that the SQL Server databases reside or is this the name of an actual SQL Server database ? If the name of the physical server is to be used, how does SQL server know which specific database the 'Login Id' and 'Password' relate to ?
June 24, 2003 at 6:58 am
It's the SQL Server, either the name or the IP address. If the name doesn't work it's due to a DNS issue (no name resolution). When you supply your login and password it doesn't go to any user database. All logins are 'confirmed' by the MASTER database. Once MASTER confirms the login it 'sends' you to the database that is set as default for that login. That is also stored in the MASTER database.
BTW-as you continue through the ODBC screens, you will come to one that will allow you to change the default database. This will NOT allow you to change the default to a database that you do not have access to.
-SQLBill
June 24, 2003 at 8:52 am
On the money. One thing I'll add is that it doesnt have to be the physical name, it could be a DNS or WINS alias as well.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply