1
vote
1answer
275 views

SQL Server 2008 R2 error: 18456, state 1: login failed for “domain\username”

I can't seem to authenticate to my SQL server using the following command: sqlcmd -S myserver -d mydatabase -U user -P password It always says, error: 18456, state 1: login failed for ...
1
vote
1answer
89 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
3
votes
2answers
2k views

Web app running as NETWORK SERVICE can connect to SQL Server but windows service running as LOCAL SYSTEM cannot

I have installed a .net web application on a Windows Server 2003 IIS server, running in an Application Pool as NETWORK SERVICE and connecting to SQL Server on a different machine using Integrated ...
1
vote
1answer
86 views

sql server 2008 express, how login as admin

I am pretty newbie on sqlserver. I just want to logon by Management Studio on a sqlserver just for backup a db. But it seems that I haven't enough permissions because I am guest. Anyone could explain ...
0
votes
2answers
321 views

SQL server performance when using integrated security for authentication?

I was wondering about the performance impact of using Windows Authentication to connect to a SQL server in a Winforms application versus using SQL Authentication. In our current model, everyone uses ...
0
votes
1answer
101 views

SS5 <maxcons> limitation issue with <group>

Have an SS5 Socks proxy server running with SS5_RADIUS_AUTH I want to set a max connections users but have run in to a problem. SS5 want's me to define user group for it. <group> define a ...
-2
votes
1answer
146 views

Set password for SQL Server 2008 R2 Account

I have just been given access to a new Windows Web Server 2008 R2 which has SQL Server 2008 R2 installed on it. When I open up SQL Server Management Studio and try to connect, it does so with Windows ...
1
vote
2answers
235 views

Authenticating Linked Servers - SQL Server 8 to SQL Server 10

We have an old SQL Server 2000 database that has to be kept because it is needed on our manufacturing machines. It also maintains our employee records, since they are needed on these machines for ...
4
votes
4answers
8k views

How can I add myself to my local sql server's windows authentication?

IT recently re-setup my laptop with 64bit windows. He installed Sql Server dev edition for me and set it up with a username and password. I logged in and tried changing Sql Server to windows ...
3
votes
2answers
616 views

Authentication between IIS & SQL Server for Load Balanced App

I'm looking to use this connection string however I'm not sure how to set this up: Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes; Previously our SQLNCLI10 ...
3
votes
1answer
1k views

SQL Server Windows Authentication NTUSERNAME is different to Windows Login

An employee at a client has just got married and as a result they have changed her details, login name et al., in Active Directory (AD). The problem is SUSER_NAME() in procedures and the NTUSERNAME ...
1
vote
2answers
239 views

SQL Server read-only user can connect local but not remotely

I have a SQL Server where admin users can connect locally and remotely, but read only users can only connect locally and get a "Login failed" error when connecting remotely. It's using SQL Server ...
3
votes
2answers
6k views

SQL Server: dbo vs db_owner role member?

I'm assinging user to a new database. What is the difference of user being a default dbo user compared to assinging login as a db_owner role member?
0
votes
1answer
183 views

Configure Apache to use SQL Server authentication

I believe it's possible to configure Apache to use SQL Server for authentication. You supply the DB connection parameters and a query to run. I suppose the contract is something like: If the query ...
0
votes
0answers
90 views

What configs are needed to make the NT challenge presented by SSRS 2008 go away?

I have a full MS BI stack (SSRS, SSAS, SSIS, SQL Server - all 2008, Developer edition) running on Windows XP Pro (work requires this OS). If a user is in the administrators group local to the ...
2
votes
2answers
4k views

How to configure Windows user accounts for ODBC network with NT authentication?

I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running ...
0
votes
1answer
129 views

Changing the Windows authentication users allowed to access SQL Server

This seems like a question that should be common enough, but I can't find anything on it. Two questions, really: How can I determine which account(s) have Windows authentication access to an ...
0
votes
3answers
2k views

How do I disable Windows authentication on a SQL Server instance?

How do I disable Windows authentication on a SQL Server instance?
1
vote
2answers
206 views

Developer Laptop with SQL Server 2008 can't login to SSIS when offsite

When I bring my Windows XP (SP3) laptop home I can still login as my domain account because Windows caches the info necessary to authenticate me when the domain controller isn't around. However, when ...
1
vote
2answers
468 views

Is it possible to integrate Computer Associates SiteMinder with SQLServer?

We have a MS SQL BI stack which the standards group wants us to move to "WebSSO" which is based on Computer Associates SiteMinder/netegrity product. I figure integrating the web component won't be ...
0
votes
1answer
258 views

Unknown Kerberos authentication pattern on SQL Servers

One of our admins noticed a strange pattern of login messages in the Windows event log on one of our SQL Servers, and after some investigation, I've found that it the same pattern can be found on most ...
1
vote
2answers
718 views

Login problems on SQL EXPRESS using a user

First time I set up a SQL server, so I hope you can help me out. I have a problem regarding logging in using SQL auth on my SQL EXPRESS 2008. I have added a user though the management interface as ...
0
votes
1answer
954 views

How to change SharePoint database authentication

I created a web application and specified SQL authentication. How can I change it to NTLM? I tried under Central Administration > Application Management > Content Databases but that only changes the ...
0
votes
2answers
1k views

Problem authenticating with SQL server 2008 server from IIS 6 server

I have 3 seperate physical servers: Old Webserver (IIS6; Windows Server 2003) New Webserver (IIS7; Windows Server 2008) DB Server (SQL 2008; Windows Server 2008) These are all non-domain ...
4
votes
3answers
4k views

SQL Server - Connect as another domain user

We use Windows Authentication for connecting to our internal SQL Server instances (a mix of 2005 and 2008). When I open SQL Server Management Studio and connect to a server it obviously connected me ...
1
vote
2answers
554 views

Can't connect to MSSQL Server 2000 with “IP Address” but works with server “hostname”

this happens after applying the SP3 on MSSQL Server 2000, I just can connect with SA login or DOMAIN\Administrators (built in) users, How can I reenable the Integrated Security connection? Hey Hey... ...
0
votes
5answers
2k views

SQL Server 2000 + ASP.NET: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I just migrated a development workstation FROM: Windows XP Pro SP3 with IIS 6 TO: Vista Enterprise 64bit with IIS 7 Since the move, one of my pages that accesses an SQL Server 2000 database is ...
4
votes
3answers
219 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 ...