The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
3answers
800 views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
0
votes
3answers
1k views

Connect to remote SQL Server instance using Windows Authentication

How can I connect to a remote instance of SQL Server (on my VPS) from my local machine using Windows Authentication? By default, if I try to connect using this method, the username is my computer ...
0
votes
2answers
570 views

SQL 2008 R2 express: Server Cannot open database requested in login 'xx'. Login fails. Login failed for user 'NT AUTHORITY\SYSTEM'

I have SQL Server 2000 installed on the server. I installed SQL Server 2008 R2 express edition as required for new application. The application runs on the same server which is Windows Server 2003 ...
0
votes
2answers
298 views

SQL Server 2008 Express, need to copy a table from one server to another automatically

We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other ...
0
votes
2answers
433 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
1
vote
1answer
211 views

SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue

I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk... I am running in the strange ...
0
votes
1answer
46 views

SQL Express 2008 uninstall not complete

How do I get rid of SQL Express 2008 after it's been uninstalled. It's all over my file system and all over the registry on 2008 R2 server sp1.
0
votes
1answer
59 views

SqlServer doesn't allow other users to login from other computers

I have a server running MS SQL Server 2008 Express. Windows Authentication is used to authenticate the accounts to determine what they can and cannot access. I have no problems accessing the server ...
0
votes
1answer
209 views

Fresh Install of SQL Server 2008 doesn't install managment studio. Help!

Ok I am running Windows 7, 64 bit. I cleaned of SQL server 2005 completely off my system leaving only SQL Compact Edition. I went here ...
-1
votes
1answer
35 views

MSSQL service fails to come up on vm restart

We have a MS SQL 2008 R2 express installation on a VM. If the entire VM node reboots then the SQL service fails to come up. Restarting the VM in isolation results in running service. We have put the ...
0
votes
0answers
26 views

SQL Server Express Application Deployment Via CD

Our company has an ancient home-grown Win-32 application which uses a SQL Server Express db. We have a salesperson at a remote office who has no reliable internet and I need a way to package this app ...