The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
3answers
391 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
235 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 ...
2
votes
2answers
787 views

Installing a new SQL Server instance fails

I've previously in my setup installed SQL Server Express 2005. Now I've switched to SQL Server Express 2008. I updated the command line parameters to those documented for the latter. If the comp ...
0
votes
2answers
36 views

How to connect to ms sql express?

I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
0
votes
2answers
456 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
284 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
424 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
182 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
40 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
57 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
202 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
32 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
145 views

Creating database from Entity Framework and Code First create database error

This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out. I'm running on MSSQL 2008 Express, EF5 and MVC4 My web.config file looks a bit like ...
0
votes
0answers
299 views

Automate Sql Server 2008 R2 Express install - silently and pre-configured

I want to create a .MSI installation of my app. One of the things that should be installed it's the SQL Server 2008 R2 Express, but i want it to be installed silently, pre-configured for all client ...
0
votes
0answers
947 views

SQL Connection String to access localhost\SQLEXPRESS

I've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a webpage in Visual Studio to, basically, SELECT * from a table in the SQLEXPRESS, but I ...