1
vote
0answers
1k views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) ...
0
votes
1answer
149 views

opening firewall 1433 port to IP address that require a direct connection

We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2. New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be ...
0
votes
1answer
212 views

SQL Server 2008 intermitent error 40 running parallel queries

Here's our setup : We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in ...
0
votes
1answer
345 views

sql server 2008 r2 can connect with connection manager but noway else

I have installed (3 times on 3 machines) sql server 2008 r2 can connect with connection manager but other program cannot connect. I can connect to remote sql servers with heidisql or with my ...
0
votes
1answer
417 views

Allow only 1 ip to connect mssql server 2008

i have a mssql server 2008 installed server. I want to connect only from my home pc (static ip) no one can connect with their machines. i have done to allow only my ip to connect the ftp but i cant ...
0
votes
1answer
545 views

Diagnosing SQL Server 2008 Timeout After Prolonged Use

After every few days of faultless operation, the following information event pops up in my database server's event log: Process 0:0:0 (0x890) Worker 0x5C55A0D8 appears to be non-yielding on Scheduler ...
1
vote
1answer
2k views

Can't connect to Sql Server 2008 named instance

I just installed Sql 2008 Express on a new server running Windows Server 2008. I know Sql is working properly, because I can connect to the db fine locally, on the server. I cannot connect to it from ...
0
votes
1answer
236 views

SQL Server connection issue

I am learning from http://msdn.microsoft.com/en-us/library/ms143432.aspx, my question is what is the differences between "Connections per client" and "user connection"?
3
votes
1answer
4k views

Problems with SQL Server 2008 - “The client was unable to reuse a session with SPID 62, which had …” [closed]

I'm having problems with my SQL Server 2008 installation (10.0.2531.0 - SP1 installed). It works as a database server for small hosting environment (about 500 sites). I'm getting errors like this: ...