2
votes
0answers
76 views

Mirrored local accounts to connect to database on different server and domain

My database client and database server are on different machines and are not connected to the same domain (this is not supported with my web host). I'm not keen to send username/password details via a ...
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 ...
2
votes
1answer
1k views

How do I log in, using SSPI, to SQL Server 2008 R2 on a server in one workgroup from a workstation in another?

We're having trouble connecting to our SQL Server (2008 R2) via SSPI. Our team has recently moved from a domain-based setup to a decentralised workgroup-based setup. Each developer has access to a ...
0
votes
3answers
567 views

Why Does A/D Account Need SQL Server Login?

I need some help on understanding the differences between Windows and SQL Server Authentication: We have a SQL Server 2008 set to SQL Server and Windows Authentication Mode. There is one A/D user -- ...
0
votes
1answer
357 views

Under which circumstances can a *local* user account access a remote SQL Server with a trusted connection?

One of our customers has the following configuration: On the domain controller, there's an SQL Server. On his PC (WinXP), he logs on with LocalPC\LocalUser. In Windows Explorer, he opens ...
0
votes
1answer
87 views

what to do with ms sql error 40 “”

I had no problem with my sql server and management studio yesterday, but today it does not connect and show me this error: A network-related or instance-specific error occurred while ...
2
votes
2answers
1k views

Windows authentication to SQL Server via IIS and PHP

We're running a PHP 5.4 application on Server 2008 R2. We would like to connect to a SQL Server 2008 database, on a separate server, using Windows authentication (must be Windows authentication--the ...
1
vote
1answer
516 views

How to trust a non Domain PC over a VPN connected via a Domain Account for SQL Windows Authentication

We are trying to enable a windows login to SQL Server from an untrusted laptop. The SQL Server has been enabled to allow the domain account to login and browse the data When a domain user connects ...
2
votes
3answers
952 views

SQL Server bulk import from fileshare. How can I get SQL Server to see the share?

I have two servers A and B. B is a database server, A is (here) a client to the database server. A tool running on server A connects to SQL Server on server B and ultimately triggers a bulk import ...
1
vote
2answers
1k views

Can't connect to SQL Server in different domain using SSMS and Windows 7 Crendential Manager

I need to connect to a SQL Server 2008 instance in another Windows domain to manage it. We only use Windows Authentication. In Windows XP, I could use the "Manage Network Passwords" feature to store ...
0
votes
2answers
107 views

trusted connection

I logged on as administrator and created a trusted connection for a software that connects to my sqlserver. Then I logged on as a regular user and checked on the db server the users connected. ...
3
votes
1answer
999 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 ...
0
votes
3answers
267 views

Can Accpac be used with Windows authentication for SQL Server?

I'm the DBA and the Accpac guy is telling me we need a SQL login for the Accpac databases. Right now I use only Windows authentication, and I don't like the idea of turning on mixed authentication if ...
1
vote
3answers
824 views

What happens to my SQL Server logins if I change a windows domain username

My question is very similar to this question Changing Windows Domain UserName but the original question doesn't explicitly answer my slight variation. If I change a windows users username (if they ...
0
votes
1answer
282 views

Configuring Windows Authentication on SQLEXPRESS

I've successfully followed the many tutorials to enable remote connections to my SQLEXPRESS Server. I'm now trying to connect remotely through SQL Server Authentication and the connection works, ...
1
vote
2answers
88 views

How to install the same user on two different servers?

I have two Windows Server 2008 servers. 1) Is a web server 2) is a db server I need to use Windows authentication to access the db server, therefore I need to create a new user on both machines. ...
2
votes
1answer
425 views

Windows service running as network service - how does it authenticate? Breaking change in W2K8?

A Windows service running as "Network Service" talks to services on other machines (here: SQL Server and Analysis Services), using Windows authentication. For authentication, we have to grant ...
2
votes
2answers
294 views

SQL Server Windows-only Authentication Strategy problem

I would like to use Windows-only Authentication in SQL Server for our web applications. In the past we've always created the all powerful 1 SQL Login for the web application. After doing some ...
0
votes
2answers
2k views

Running a Windows service under a domain account from a non-member server

I've got a standalone Windows Server 2003 running SQL Server 2005 and a Windows Server 2003 Active Directory domain controller. Using maintenance plans/SQL Server Agent, I'm trying to write the ...
0
votes
2answers
183 views

Is it possible to use windows authentication to control access to an external SQL server database?

We're planning to move a large portion of our database to our web host's SQL server. The SQL server is only accessible through SQL logins. Is there any way to set something up locally that would ...
0
votes
1answer
128 views

What's the recommended way to set up a windows service to connect to a remote SQL Server?

I have a service on server A that needs to connect to a SQL Server instance (2005 or 2008) on server B. Both A and B are on the same domain. What are the best practices for configuring both the ...