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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-04 : 07:28:58
|
| Robert writes "I have a 2000 SQL Server with SP3 on my network server, let's call it SQL1. I can back up the database files and restore them on my home computer so that I can work from home. I am also using the SQL Server 2000 with SP3 (Disk 2 from the installation CD's). The problem is that when the database is created on the home PC, it makes a name like \\ROBERT\SQL1 instead of \\SQL1. My programs that tied to them directly (Access XP) can't find it due to the name being different. Is there any way to make the names the same? Windows 2000 won't allow a blank name for the computer. I am not afraid to do a registry hack if that will help. I can't seem to find any answers any in the documentation.Thanks,Robert" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-04 : 13:14:18
|
| \\ROBERT\SQL1 is a named instance of SQL Server and not a database name. If you want the name to be \\SQL1, then your machine has to be named SQL1 and you must have installed the default instance. It is using ROBERT because that is your machine name and it is using SQL1 as the named instance because that is what you used when you installed SQL Server.Tara |
 |
|
|
|
|
|
SQL Name