.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Unable to connect to SQL Server 2008 R2 Database without being admin of the machine

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I am receiving the following error when I try to connect to my new SQL Server 2008 R2 machine:


Msg 18452, Level 14, State 1, Server <server name>, Line 1 Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

I'm running the following command to test the connection:

sqlcmd -S<Server Name> -E -Q"Select @@servername"

On the server I'm getting the following from the SQL Server logs


03/31/2011 20:31:58,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT:]

03/31/2011 20:31:58,Logon,Unknown,Error: 18452<c/> Severity: 14<c/> State: 1.

03/31/2011 20:31:58,Logon,Unknown,SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT:]

03/31/2011 20:31:58,Logon,Unknown,Error: 17806<c/> Severity: 20<c/> State: 2.

What is odd is if I put the domain user in as Admin of the machine then it connects just fine.  I have tried just about everything I can find and I just cannot get it to work. Anyone have any clues???


View Complete Post

More Related Resource Links

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Unable to connect SQL Server 2008

Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Cannont connect to New Installation of SQL SERVER 2008 from New Vista Ultimate machine(s)

I have a new SQL Server 2008 Development edition installation on a Newly setup Server running Windows Server 2008 Enterprise edition.  The server is mainly a file server and is not setup as a domain controller.  Since my test environment is fairly basic (server and two Vista Ultimate machines) I thought the connection through data sources on the client machines would be straight forward.  But it isn't working.  I can see the server, ping the server, etc. but when I try and connect the client through a system DNS it will not connect using SQL Server authentication using a loginId.  (since it isn't on a domain, I can't use Windows NT Authentication).   The error is SQL Error 10060 and SQL Error 17.  (connection failed and SQL Server does not exist or access denied)  Any thoughts or suggestions are appreciated. WB

Unable to connect Excel 2003 from linked server in sql 2008 64 bit


I was unable to connect to excel 2003 with linked server created in sql server 2008 64 bit. This was working fine with sql server 2005 32 bit.

I know that there no 64 bit drivers for JET drivers, but i am looking for some alternative ways to do the same job.

I dont want to migrate to Excel 2007.

Thanks in advance for all your help.


Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






Unable to connect to SQL Server Database


Hi All,

I actually tried all of posted, at least over here, regarding installing Service Level Dashboard V2 on a WSS 3.0 stand-alone server, which I would use with SCOM 2007 R2, and all didn't work; I tried stopping the "Server 2005 Embedded Edition (MICROSOFT##SSEE)" and set it manual, didn't work.

Like others, I installed all pre-reqs before WSS 3.0, fine, no issues until running the ServiceLevelDashboard_x86.msi. I checked permission pertaining to the account used to run and connect to the Operations Manager Data Warehouse Server, local admin. The weird thing is I used the same steps that had been used to set these up on a testingserver, which was running fine. Now that we need to set these up on a production server. But those steps wouldn't work any more?!

Any helps, hints, lessons are really appreciated

Unable to attach database in sql server 2008




I have Windows Vista Home Premium and the 180 day evaluation version of SQL Server 2008 installed.

I am getting the following error when trying to attach the AdventureWorks2008 database. I was able to attach the Northwind:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'HOME-PC'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


FILESTREAM feature is disabled.
A file activation error occurred. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL10.M

Here I go again. Unable to connect to SQL Server database.


I just recently decided to uninstall SQL Server 2008 Express Edition in favor of installing SQL Server 2008 R2 Express Edition. Now I can't access the "security.aspx" page via the ASP.NET Configuration icon. Clicking it yields the following error. "Unable to connect to SQL Server database."  My guess is that the account that Visual Web Developer Express 2008 edition is launching to "attempt" to create the default ASPNETDB.MDF file in the App_Data folder does not have sufficient permissions to execute the command through the local SQL Server instance.


This is one of the most frustrating issues I have ever had to deal with.  I have no idea what is going on behind the scenes when I click on that "ASP.NET Configuration" icon because of the incredibly abstract error messages that Microsoft likes to dole out. It would be nice of Microsoft to tell me the exact name of the account that SQL Server is refusing. That would be kind of them. Maybe in a future version? Anyone who can explain the relationships to me between

1)Visual Web Developer Express Edition 2008

2)IIS Manager 7.0 and

3)SQL Server Express Edition

My questions:

What is the name of the user account that Visual Web Developer uses to try and create the ASPNETDB.MDF file in the App_Data folder of

How to get database (other than AdventureWorks) to connect to SQL server 2008 Analysis services for


I am making a project on Data Mining, I am using the Office 2007 Excel, SQL server as a sample mining tool, i have practiced and understood using Adventure works database , but i NEED a different Database so as to connect it to analysis service and demonstrate data mining using excel in my own project, WHAT AND HOW DO I GO ABOUT IT?


unable connect to databae in sql server 2008

You cannot vote on your own post


i have installed sql server 2008 r2 in my DELL laptop with windows 7 OS. I have chosen default instance MSSQLSERVER while installing and Server name as gowtham. After installing i have restored a database backup in the name ADMIN. when iam trying to connect to ADMIN database, i am getting an error message "Unable to connect database -Admin". I have tried by switching of fire wall also. i am trying to database in the local system,not through network. can any one help in this.....



sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

unable to connect to database



I am using visual studio 2005 and sql server 2005.

I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:

<?xml version="1.0" encoding="utf-8" ?>
        <add name="quizdb"
            connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />
i have retrieved connection string property through configurationmanager class 

and when i m connecting to database  it gives me a runtime error:


Sql Exception was unhandled

System.Data.SqlClient.SqlException was unhandled
  Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located

How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance

need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Unable to Connect to server

I have install sql server 2008 on window 7. But connection to server is failed. These are the options. Sever Type Server Name. Authentication. Login. Pasword. anybody have answer my question????
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend