1
vote
1answer
216 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
0
votes
1answer
104 views

Linked Servers in SQL Server

I have created a linked server and wish to execute a job that queries the linked server and writes the result in a local database.Ihave tested the connection to the linked server and it was fine. I ...
1
vote
1answer
634 views

SQL Server: Cannot log into SQL Server Management Studio on Server

I installed SQL Server 2012 on a Windows Server 2012. I am going back a few days later and unable to log into SQL Server Management Studio (SMS) using Windows Authentication, even if I launch SMS ...
1
vote
1answer
255 views

Can't get access to my SQL Server on localhost

Recently I have been having problems accessing local connection in my SQL Server Management Studio 2008. I am connected to a network, and my account has administrator rights on all the computers. ...
-3
votes
1answer
419 views

How do i Create sql login user with using QUERY?

How do i Create sql login user with using QUERY? I would like to use the following parameters. User Name = campus User's Password = 123 Policy = OFF Default Language = English Default Database = VM1 ...
2
votes
3answers
6k views

Can't login to SQL Server in Single User mode

I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error: Login failed for user 'LOCALSERVER\Administrator'. Reason: ...
1
vote
2answers
584 views

Want to find cause of recurring failed SQL Server 2005 login attempts

I've been noticing recurring failed logon attempts onto our SQL server. It happens every minute with the same login. An example from the log file viewer 10/18/2011 13:54:50,Logon,Unknown,Login ...
0
votes
2answers
363 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 ...
4
votes
1answer
145 views

Attempt to access SQL Server with the user SA [duplicate]

Possible Duplicate: Attempt to access SQL Server with the user SA I'm suffering an attempted invasion by brute force. A bot is trying to figure out the sa password. How do I restrict logins ...
1
vote
3answers
830 views

MSSQL Mirroring Failover: Login failed for user

When MSSQL DB Mirroring fails over, our script won't login, fails on: Cannot open database requested by the login. The login failed. Login failed for user ... The way I can fix this is by running: ...
0
votes
2answers
833 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 ...
6
votes
2answers
8k views

Login failed for “IIS AppPool\ASP.NET v4.0” - SQL Server Web

I'm trying to migrate a website from SQL Server 2008 Express to SQL Server Web, and the website is having trouble accessing the database. In truth, Express was only ever used by running the website ...
4
votes
3answers
2k views

In SQL Server, how do I create a login for an existing user?

I restored a database from one SQL Server instance on to a different SQL Server instance. The database allready has users added to it. But they don't have Login's for the new SQL Server instance. I ...
2
votes
1answer
713 views

SQL Server Instance login issue

I've just brought up a new installation of SQL Server 2008. I installed the default instance as well as one named instance. I'm having a problem connecting to the named instance from anywhere ...
2
votes
2answers
338 views

SQL Server 2005 random login failures for windows forms application

One of our VS .NET 2008 windows forms applications runs from multiple client machines. The application randomly has login failures from random machines and from random places in the code. The login ...
3
votes
2answers
192 views

SQL Server Error when logging in with SQL login

I have a website that I need to access a sql server. In development using windows login worked fine, but now that I have deployed it to the webserver it cannot access the DB because it is running as ...
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 ...
2
votes
1answer
762 views

SQL Server 2005 does not start after installing SP3

I have a pretty ridiculous problem. So I've installed SQL Server 2005 on a Window Server 2008 machine. I was working my way through the service packs, provisioning two users to have full rights to ...
0
votes
1answer
83 views

cannot start any SQL2005 services

When installing SQL server 2005, i provisioned a domain account to have the logon rights to SQL during the configuration wizard. however when i log into the machine as the domain account (admin) I ...
0
votes
1answer
71 views

SQL server login error

I am trying to login to SQL server 2005, and it gives me an error 18456.. This is very funny...I go to advanced option and set network protocol as TCP/IP it does not work..if I leave it as default it ...
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 ...
4
votes
3answers
225 views

Permissions for shipping SQL Server 2005 transaction logs

I'm trying to ship transaction logs from Server A to Server B. I keep getting permission denied errors when the agent tries to run because it isn't using the right credentials to connect to the backup ...