0
votes
1answer
131 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
3answers
46 views

Unable to locate any server in SQL Server 2008

I am a newbie. I recently installed SQL Server 2008 on my server. When I try to login, it does not show me any server when in Browse (see below) What could be wrong? Please let me know.
3
votes
1answer
854 views

Unable to start SQL Server 2008 service

I am running SQL Server 2008 R2, and I am having an issue with my local server instance. At first, this only happened occasionally and seemingly completely randomly, but was fixed when I restarted my ...
4
votes
2answers
2k views

Why does the .NET Folder.CopyHere Method not allow dialog suppression for .ZIP files when run within a SQL Server Agent PowerShell job step?

I am using PowerShell in a SQL Server Agent job step to automate the extraction of .ZIP file contents to a directory. Based upon highest-voted answer on this question: How to zip/unzip files in ...
0
votes
1answer
177 views

SQL connection with mirroring still working after a failover

I have a windows service application that is instaled on two servers, SQL01 and SQL02. On both server there is a SQL server (X1 and X2), which have the same content. A mirroring partnership was set up ...
0
votes
2answers
2k views

how to quickly check communication protocol used by SQL Server

I am using VSTS 2008 + C# + ADO.Net + SQL Server 2008. When connecting from another remote machine, normally TCP/IP protocol is used by ADO.Net client to connect to SQL Server 2008. When connecting ...
0
votes
1answer
271 views

SQL Server connection issue

I am using VSTS 2008 + .Net 3.5 + C# + SQL Server 2008 Enterprise on Windows Server 2003. I am using the following connection string, and labtest1 is the local machine name and I connect from local ...