1
vote
0answers
25 views

Cross Server and Instance Login SSIS SID or ID Issues

I have some challenging login/SID/ID issues with authentication between databases on separate instances and servers. We have a Development, Test, Pre-Production and Production server/instance ...
2
votes
0answers
361 views

How to set up users in SQL Server 2008 Express over workgroup? (no domain)

The situation is this: simple network, one server not a domain controller, running SQL Server 2008 Express (64bit). 8 workstations running windows 7 pro connected to it. Last week after Windows ...
1
vote
1answer
3k views

How can I get my linked server working using Windows authentication?

I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs ...
1
vote
0answers
90 views

Re enable Windows Authentication [closed]

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
4
votes
3answers
2k views

Re enable Windows Authetication in SQL Server

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password. I ...
2
votes
1answer
966 views

Cannot connect to SQL Server after setting sa password to blank

I have installed SQL Server 2008 R2 on a Windows 2008 server. I need to set the sa password to blank for some reasons to make an application works; but it seems like the password changes automatically ...
2
votes
1answer
204 views

SQL 2008: Why is *any* user, with minimal permissions able to restart/stop the SQL instance through Management Studio

So I'm on a project that I need to help admin SQL 2008 . I'm coming from a MySQL background. Why is it that a basic user, with the most basic/default permissions, through Management Studio is able to ...
0
votes
1answer
9k views

user “sa” cannot connect to SQL Server Express 2008 R2

Goal: connect to SQL Server Express 2008 database using SQL Server authenticated account "sa", rather than my Windows authenticated account. When installing SQL Server 2008 Express, I took all ...
1
vote
2answers
1k views

Login Failed for User

I have written a code in Visual Studio.NET and used data from SQL Server 2008. But after debugging, it says: Login failed for user 'sunny'. When I try to set the user as something else, it keeps ...
2
votes
2answers
364 views

How do I monitor which Windows user is logging in as SA? [duplicate]

Possible Duplicate: ProcessID Owner with third party app Several of our applications use the sa account to login to our SQL Server 2008 instance. As these applications are poorly designed ...
0
votes
1answer
149 views

Connect to a Windows Authentication SQL server in SQL Server Authentication mode?

Is it possible to connect to a SQL server in SQL Server Authentication if the server has been installed with Windows Authentication?
6
votes
2answers
1k views

securely exposing sql server 2008 for windows authentication

My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet. We have sql ...
1
vote
1answer
316 views

Grant access for any logged in user for common database

In SQL server 2008, I have one database that is a common database that is accessed thru stored procedures in all other databases. Each of the other databases have their own login. I need a way that ...
2
votes
1answer
845 views

Is it possible to specify Active Directory username and password in connection string?

My organization uses Active Directory to control access to our databases. Building web applications and as part of our CI process I would like to specify the credentials in the connection string. Is ...