0
votes
1answer
18 views

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i ...
0
votes
0answers
97 views

Connection Timeout Expired

Message:Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and ...
1
vote
0answers
80 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
0
votes
1answer
130 views

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out ...
6
votes
1answer
5k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
0
votes
1answer
113 views

Can a network failure cause a user to be removed from SQL as an authorized user?

We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database. I believe we have just setup database mirroring too in case the ...
2
votes
1answer
201 views

Electricity gone off while shrinking database, how can I recover my database?

While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery". How can I recover it?
0
votes
2answers
66 views

MSSQLSERVICE 2008 R2

I have Microsoft SQL Server 2008 installed and running but I can't seem to see COMPUTERNAME/MSSQLSERVICE at all. I have COMPUTERNAME/SQLEXPRESS but that's not the right one. Ideas?
0
votes
1answer
456 views

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial ...
1
vote
2answers
603 views

Cannot resolve the collation conflict between “SQL_Latin1_General_CP437_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation

I'm trying to copy over a schema from one server to another, and I keep getting the following error and I have no clue where to start from to debug this issue... Error 2 SQL01268: .Net SqlClient ...
0
votes
1answer
120 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
0
votes
2answers
509 views

what type of replication transaction should I use?

I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different ...
1
vote
1answer
639 views

When installing SQL Server, “Unhandled Exception: System.Security.SecurityException: Request failed.”

Brand new Windows Server 2008 R2 install handed over to us from Windows admin group. I try to run the SQL Server 2008 R2 install and get this error: Unhandled Exception: ...
0
votes
1answer
252 views

Supertype question from a mega noob

I've tried a couple database creation tools (MS SQL Server, MySQL Workbench, etc.) and I cannot figure out how to create a super-type relation (complete, disjoint). Below is an example of how it looks ...
0
votes
2answers
70 views

How to run :connect (local)

When I run the following on SQL Server 2008 R2, I am getting Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ':'. What is wrong? :CONNECT(local) Go USE msdb go
0
votes
2answers
231 views

SQL 2008 R2: How to determine who restored the database?

Our database was recently restored. It caused some real grief. Is there an audit mechanism to determine who executed the most recent restore? Thanks.