0
votes
1answer
93 views

Cannot log into SQL Server 2008

I created a login name in SQL Server 2008 by right click on security then new->login specify a name , password and server map. Right-click on SQL Server instance at root of Object Explorer, click on ...
0
votes
2answers
337 views

Configure user login and stored procedures permissions on SQL Server

I'm a software developer finishing a web application. The app uses the database "DB1" in my SQL Server 2008 "SQLServer_1". I would like to create a limited user that the web app will use in its ...
1
vote
1answer
7k views

MSSQLSERVER Exception occurred while enqueueing a message in the target queue. Error 15404, State 19

I am getting a bunch of messages in the Windows Application Event Log. Here is exact text from Event Viewer: An exception occurred while enqueueing a message in the target queue. Error: 15404, State: ...
0
votes
2answers
735 views

Set a login with username/password for SQL Server 2008 Express

I would like to set a password and username for connecting to a server with SQL Management Studio 2008. I set up SQL Server 2008 Express on a customer's computer to host a DB used by an Access 2007 ...
2
votes
3answers
2k views

Access to SQL Server when administrator account deleted

An interesting situation here. We have a database server, used for testing only, where someone went in and deleted the administrator login. Since this is a test server the was no other admin level ...
1
vote
3answers
673 views

urgent! I deleted the default user in sql server 2008. help

i saw this in logins computername/username and i deleted it! now can not log into sql srv mangmnt sttdio 2008 no the mixed mode is not enable, can not use the sa account its disabled default ...
2
votes
2answers
2k views

Can't login to SQL Server after moving machine to different office/domain

Our company has just been bought and the over the weekend I have brought up the last few machines to plug into their network (they are under a different Windows Domain). The last machine is our Vault ...
0
votes
2answers
2k views

Login Failed For User PCname/Guest

I'm getting this error message while I'm trying to connect a sql 2008 database which is in another computer.
0
votes
4answers
12k views

Can't access SQL Server 2008 from workstations, but can from server

We have an app that can use mssql2k or 2k8. We've been using 2k but I decided to try 2k8 to compare. I installed in on our win2k3 server alongside mssql2k. In the ODBC applet on the server, I was ...
1
vote
2answers
7k views

Can't connect to local database in SQL Server (2008) Management Studio

An IT guy at work remoted into and installed SQL Server 2008 Developer on my terminal, and at first everything seemed to be set up correctly. However, when I go into the Management Studio, I can't ...