1
vote
1answer
235 views

what instance name in connection string for Dynamic management Views

I want to run the following query :: SELECT S.* FROM sys.dm_exec_requests S JOIN sys.dm_exec_sessions R ON r.session_id = s.blocking_session_id It works when i run it in SQL Server Console. ...
1
vote
3answers
308 views

Can't connect to SQL server

I have SQL 2008 server installed on the local machine with the instance name "SQL2008". I'm trying to connect to it using Management Studio. I can connect with the sa authentication but am unable to ...
6
votes
5answers
4k views

SQL Server Timeout on first attempt

I'm having a strange issue where I try to attach to SQL Server 2008 running on a second computer (both machines running Win7 64-bit), either through the Data Sources in Visual Studio or via the SQL ...
1
vote
1answer
7k views

SQL 2008 not accepting connections

Setup: SQL 2008 Standard SP1 64Bit on Windows 2008 - one CPU, 8GB of memory The server is dedicated to SQL Server. The server memory settings were as default (min 0 max 2000GB) Connections from 8 ...
0
votes
2answers
1k views

SQL 2008 - Server not found or not accessible

In my home network, I have three machines - trying to do a lab for mirroring on SQL 2008. > Machine A can connect to B and C. > > Machine B can connect to A and C. > Machine C cannot ...