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 |
|
manolain
Starting Member
1 Post |
 Posted - 2007-10-18 : 10:53:49
|
| Hello everybody, on my first post on this forumI just installed SQL Server Express 2005 (server) and created default instance SQLEXPRESS, so that, when I want to access in remote mode, the server conn string is: <servername>\SQLEXPRESSBut I have been told there is one way to configure SQL Server so that only one instance is allowed, so you dont need to specify any. If this was true, I would only need to give 'servername' to access remotely.Is this true? How can I achieve this? Will it be possible to doing it after having installed software, or do I have to uninstall and install it again?Sorry if this is too basic, I am just having first contact with SQL ServerThanks very much for your help!!! |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-10-19 : 12:05:50
|
| If u have installed sql server 2005 express then u must have to give servername\sqlexpress .RKNAIR |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-19 : 21:50:30
|
| If you installed sql as default instance, you can connect to it with host name. |
|
|
|
|
|
|
One instance in Express 2005