When I'm trying to connect to my database, I need to provide the instance name like so:
192.168.10.10\SQLEXPRESS
I'd like to be able to just connect to my database without having to type the instance name, like so:
192.168.10.10
How can I accomplish this? I'm using SQL Server 2008 Express R2
Best Answer
That's not a server name, it's an instance name, and it's necessary, as there may be several SQL instances running on a single server.