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

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

Windows 7 connection to SQL Server Express 2005 on Windows Server 2003

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I have SQL Server Express 2005 running on Windows Server 2003 R2.

I have several remote machines running Windows XP that connect to the database engine with no problem.  I'm using an Access adp to connect.

Just connected a Windows 7 machine and installed SQL Server Express 2005 on it and cannot connect to the db engine on the server. 

Error is:

Test connection failed because of an error in initializing provider. Login failed for user '. The user is not associated with a trusted SQL Server connection. 


I am on the network and connected fine and can access files on the server.  I am using the same connection protocols in the Data Link Properties that the XP machines use.

Any ideas are greatly appreciated.



View Complete Post

More Related Resource Links

SQL Server 2005 Express ODBC connection error with Windows Vista Business

I have a SQL Server 2005 Express Edition installed on a Windows Server 2003 domain machine. When I do a connection with a client running Windows XP through the SQL 2008 ODBC driver I have no problem.  The problem is when I try to establish a connection using a client running Windows Vista Business Edition which is a member of the domain. Please help me to solve this issue.

Thanks in advance
Danilo Bucheli Sánchez

SQL express 2008 r2 on windows server 2003

install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."

Does SQL 2005 Enterprise Edition come preloaded on Windows Server 2003 Virtual Server.

Does SQL 2005 Enterprise Edition come preloaded on  Windows Server 2003 Virtual Server. I found this link http://www.microsoft.com/downloads/details.aspx?FamilyID=77f24c9d-b4b8-4f73-99e3-c66f80e415b6&displaylang=enMr Shaw

How should I configure Asp.NET on IIS 6, Sql Server 2005 and SSRS 2005 across 2 Windows Server 2003

I was running a MIS reporting solution on a single server running MS Windows 2003 Server and Sql Server 2005. The solution was built using ASP.NET 2.0 on IIS 6.0, Sql Server DB & SSRS. I now have purchased a 2nd server running MS Windows 2003 Server and Sql Server 2005. What is the best configuration to split the following application components across the 2 physical servers? ASP.NET web application SQL Server 2005 Datawarehouse SSRS Web Applications (Reports & ReportServer) SSRS Databases (ReportServer & ReportServerTempDB) The hardware configuration of the 2 servers are as follows Server 1 MS Windows Server 2003 Enterprise Edition SP2 Intel(R) Xeon(R) CPU 5150 @2.66GHz 16 GB RAM Sql Server 2005 SP3 Standard Edition Smart Array P400 in Slot 1 (SAS Array A with Spare / SAS Array B with Spare) Drive C: 68.33 GB | Drive D: 273.40 GB Server 2 MS Windows Server 2003 Standard Edition SP2 Intel(R) Xeon(R) CPU X5570 @2.93GHz 4 GB RAM Sql Server 2005 SP3 Standard Edition IBM ServeRAID-MR10i SAS/SATA Controller Drive C: 135GB | Drive D: 556 GB | Drive E: 271 GB Any suggestions would be of great help

SQL-Server 2005 x64 / windows server 2003 x64 crashes during file copy

Hi We are running: Microsoft SQL Server 2005 Standard - 9.00.4294.00 (X64) Microsoft Windows Server 2003 R2 Enterprise x64 We have gigabit interface. Today we copied a file (using robocopy) from our databaseserver to another server (backup-server). The copy was started from the backup-server and source were specified using UNC. The copy were using about 20% of the bandwith (about 200Mbit). During the copy, sql-server reported several errors, for example: AppDomain 15 (mp.dbo[runtime].14) is marked for unload due to memory pressure. The client was unable to reuse a session with SPID 75, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. ***Stack Dump being sent to [PATH\SQLDump0005.txt Resource Monitor (0x1384) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 0 KB. Approx CPU Used: kernel 15 ms, user 218 ms, Interval: 428541. So to me it appears that sql-server crashed during a file copy. We have 27 GB ram. With 24.5 GB dedicated to SQL-Server. The files we copied were quite large, some over 50GB. I found a similar issue about this: http://support.microsoft.com/kb/920739/ Do you think the issue above could be the cause of the sql-server crash? ///Patrik

ODBC connection to SQL Server 2005 Standard (on windows xp) with Windows authentication does NOT wor

I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

Installing SQL Server 2005 management studio express with Windows 7

I have bought a new laptop with windows 7 premium and i cannot install sql server management studio express. I have downloaded sp3 and i still reveive an error message that it is not compatible with the os. please help

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

MS SQL Server 2005 and Windows server 2003 Environment




I wish to know how SQL Server 2005 is linked to Windows server 2003 Environment. I have knowledge about oracle databases. But Microsofet products are new to me.

To put it simple purpose of SQL Server 2005 and Windows server 2003. How both are linked ?




Use Visual SourceSafe 2005 via COM interface on Windows 2003 Server 64-bit



I'm trying to use Microsoft SourceSafe 2005 COM (published via ssapi.dll) in my 64-bit application running on Windows 2003 Server 64-bit. The attempt to get instance of the interface fails with "Class not registered" (REGDB_E_CLASSNOTREG) error. As many posts in other forums and MSDN documentation explain it is happening because of separation between 64-bit and 32-bit implementations. In other words the process in 64-bit doesn't see registry entries made for 32-bit applications. (I checked and see the registry entry under $/HKLM/SOFTWARE/Classes/Wow6432Nodes/CLSID/{Class ID}). However, I need my app. to use SourceSafe services.

Please, advise how I can invoke COM interface implemented in 32-bit from my 64-bit application. Since the 32-bit application isn't mine I can't recompile it with 64-bit... :(


Thank you.

Regards, Leo

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) windows update install error 0xD

I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500

How to Install MSDTC on a multi Instance SQL Server Fail OverCluster (SQL 2005 & Windows 2003 R2 x64


I am installing 2 SQL instances on a fail over cluster.

Currently I have my Quorum and DTC resources on the default Group and the 2 sql instances on 2 other groups.

In this way would the DTC resource  be available for both the SQL groups or is there any other way i should go about doing this ?

SQL Server Express 2005 on localized Windows



SQL Express 2005 SP3 silently installs - by using command line options and switches - well on all English editions of Windows.

However, when it comes to German (localized) Windows 7 (I suspect that other German OS editions as well), SQL Express fails to recognize recommended SQLACCOUNT="NT-AUTORITÄT\SYSTEM"; simple removal of this option from command line - and silent install goes through but sets default account to Network Service, and we really need LocalSystem instead. Oh, manual installation goes fine with all configurations, including LocalSystem; unfortunately we have to use silent install for all our customers.

Similar problem detected while installing SQL Express 2005 on French Windows 7 - SQLACCOUNT="AUTORITE NT\SYSTEM" is not taken well by installer.

Please kindly recommend a solution for this issue

Alex S

Unable to Install SQL Server 2005 Express Edition on Windows 7



 i am trying to install SQL Server 2005 Express Edition on Windows 7. it requires to install Windows installer also. While installing Windows Installer it gives me error that " Do not have enough storage Space in Disk", however i have 150 GB free space in HD.

Please help.. Thanks in advance

crash seen in sql server 2005 on windows 2003 server in Itanium 64 bit

 Defaulted to export symbols for C:\Program Files\Common Files\System\Ole DB\sqloledb.dll -
function: sqloledb!SQLDebug
        000006fa`fa480538        nop.b  0 ;;

        000006fa`fa480540        ld8.a  r73=[r29]
        000006fa`fa480544        setf.sig f6=r27
        000006fa`fa480548        addl   r63=ffffffff`ffffffff, r0

        000006fa`fa480550        setf.sig f7=r28
        000006fa`fa480554        cmp.eq.unc p15, p14=r0, r36
        000006fa`fa480558 (p15)  br.cond.dpnt.many sqloledb!SQLDebug+23060 (000006fa`fa480570) ;;

FAULT ->000006fa`fa480560        st8    [r36]=r63
        000006fa`fa480564        nop.m  0
        000006fa`fa480568   &

install sql server 2005 express on 64 bit windows


I am trying to install sql server 2005 express on 64 bit windows but i get a error message saying SQLncli_x64.msi file is missing and asks me to download it.

How can i fix this problem to install the SQL server on my Windows XP x64 Edition?

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