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.
| Author |
Topic |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-02-28 : 07:55:38
|
| Generally I install SQL 2005 using the Default Instance Name. When asked for the SQL server (setting up the ODBC connection) I simply enter the name of the server.I now have installed a new SQL 2005 server, and I gave it a unique Instance Name. When asked for the SQL server (setting up the ODBC connection) what name do I enter? I assume it has to be more than the server name as the SQL server is unique. What format do I use to enter the unique name of the SQL db?Any help appreciated.Thanks,Kerry |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-28 : 07:58:21
|
| Servername\InstanceNameHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-28 : 08:03:39
|
quote:
Originally posted by harsh_athalye
Servername\InstanceName
That's exactly what I entered and it returns a failed to connect error?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:18:30
|
| Need servername only for default instance. |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-03-02 : 03:24:37
|
| When installing sql server 2005 you can always install only one default instance. But on one sql server you can have more then one instance - which must have a name (not default).And based on your authentication mode (windows or sql) it is also relevante for accessing your instance; if you don't have a admin rights or you've forgotten to set instance username and password, you won't be able to access the instance.And sql server 2005 does support ODBC connection but since it's old and slow, it's better to use OLE DB connection. |
|
|
|
|
|
|
Connect to a unique instance??