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

Top 5 Contributors of the Month
Post New Web Links

WSS 3.0 "Unable to connect to database." from other computers only

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

Hi everybody,

I have a strange problem with recently installed WSS 3.0…

I can navigate to the site from front end server, but when I am on any other machine I receive “Unable to connect to database.  Check database connection information and make sure the database server is running.”  error. In event log I see “Cannot connect to SQL Server. MYSQLSERVERNAME not found. Additional error information from SQL Server is included below.  [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This message is logged only when user tries to reach the site from another machine. When I try this from front end server it works OK and there is no error in event log.

Due to our specific situation WSS was configured to use sql authentication for connecting to database.

What could be wrong?

Thanks in advance!


View Complete Post

More Related Resource Links

Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More


If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

Scott Mitchell

MSDN Magazine July 2009

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 i transfer a database between to computers

How do i move a database that i use for my webbapplication from my old computer to my new? I tried backing up the db on the old computer createing  a.bak file and then restoring it in the new computer using "restore database". This is the error i get:"TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device 'G:\Douments and files\Web Project\Finlandsinstitutet\App_Data\dbFinin.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------  The media family on device 'G:\Douments and files\Web Project\Finlandsinstitutet\App_Data\dbFinin.bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer

Connection between 2 computers via dial up modem without internet in c#.

Hi Is there any way to connecting to computers via Dial Modem without internet? Like windows Hyper terminal. making connection sending files between computers. Just Connection Between two Computers Directly and sending FIles. i want just connection via dial up modem and sending file over this connection. thanks.

Controls appear as different sizes on two different computers

Hello, i've got a very strange problem. I've noticed that when i build a windows form, some of the controls appear as different sizes depending on the machine on which they are running. For instance, if a text box is 200 long on one PC, it will display as 50 long on another. Has anyone experienced this problem in the past?

Use of "Select Users, Computers, or Groups" dialog box

Dear all, Currently i am trying to create a website with domain login using Visual Studio 2010 and ASP.net 4.0 . I had a table in SQL that keep track of users with rights to enter this website based on thier employee number. The administration role to maintain this rights table will be given to some non-IT department users via the website and i wish to make use of the "Select Users, Computers, or Groups" dialog box for these users to add any new user to the rights table. I have 2 main reason to use the "Select Users, Computers, or Groups" dialog box if possible. 1- Allows the administrator is search and add users easily. 2- Retrieve information of the new users like employee number, employee name, email address without much validation in the web.   Can someone enlighten me on what are the references that i need like Active directory and how to pop up this dialog box and retrieving information from it as well using the web? Thank you in advance Signed Rhico

Cannot Access Reports from Computers Within Network




I am able to access reports from my computer that has the SQL Server (2008) installed, but can't seem to access from other computers in the network. All I get is

"The permissions granted to user 'MyComputerName\Guest' are insufficient for performing this operation. (rsAccessDenied)"

Can someone please help?

I tried creating user "MyComputerName\Guest" and assign permission to view reports, but still cannot get it to work. Am I doing something wrong?

Here are some details from my Report Services Configuration Manager

Service Account is set up to Use built-in account : Network Service

Current Report Server Database

SQL Server Name : MyComputerName\ServerName

Database Name : ReportServer$ServerName

Report Server Mode : Native

Current Report Server Database Credential

Credential : SQL Account

Login : sa

Password : **********



Does a SQL Server Compact 4.0 database support simultaneous access from different computers?


For example, if an sdf file is on a network server, could two network clients running SQL Server Compact 4.0 access the file at the same time?

This was not possible using SQLCE 3.5. I'm wondering if it's been added to 4.0 (so that it brings back the one advantage of using an Access db.)

SharePoint 2010 calendar synch with MAC computers/Entourage


Is it possible to sync a SharePoint 2010 calendar with Entourage for MAC users?

Do 32 bit apps work on 64 bit computers?


I work on a website and want a friend to help.  He has a 64 bit laptop.  So I told him to download visual web developer express (2010) and install it.  It doesn't install.  I suggested that this is due to his 64 bit computer.

Also, I've written several utilities that I've compiled in Visual C# 2010 express on a 32 bit computer, and I want him to be able to run them.  Will the 64 bit vs 32 bit difference mean that they cannot run?



get hardware information in local network computers using vb.net

Hi i am currently developing a software where it can get hardware information in a local network computers like getting the RAM size, getting mac address as well as getting hard disk drive capacity.

I have no problem in getting those information in my local computer but the problem is on getting those information to my local network computers.

can someone help and guide me to this development.. thanks!

Unable to connect to Database | ASP.NET Membership and Entity Framework


Ok, so this is my first Solution using the Entity Framework (EF). Here are my steps so far:

1) Created Database named: BSA with an owner of username/password (AspNetServicesUser/password)
2) Created Entity Data Model (EDM) in a separate project (contained within the same solution)
3) Created an ASP.NET Web Application with basic functionality (new project within the same solution)
4) Added Reference to the EDM in Web App and added Connection String to the EF
5) Decided I wanted ASP.NET Membership added to the Web App
6) Configured SQL Server for Application Services using aspnet_regsql.exe on BSA database

Now, I need to know: 
a) How do I create the connectionString for the Web.config file in the WebApp?

Errors I receive:

I get this error using the ASP.NET Configuration Tool under the "Security" Tab:

Login failed for user 'AspNetServicesUser'.

I get this error using the ASP.NET Configuration Tool under the "Provider" Tab --> Select a single provider for all site management data --> Test

Could not establish a connection to the database. 

If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database

Unable to connect to database. Check database connection information and make sure the database ser



I am using MOSS2007. My MOSS site was working fine for last 1 month and today suddenly it started to show me below message

"Unable to connect to database.  Check database connection information and make sure the database server is running."


On my server, SahrePoint admin site is working. Other port site is also working. Only my MOSS site is showing me above message.  Can anyone helkp me to resolve this issue.

What does the sqlcmd -L switch's "locally configured server computers" mean?


Now sure if this is the right place to post this but... I’m looking for each of the installed instances of SQL Server on my network. I have already been pointed to sqlcmd –L, which gives back a list of what are called “locally configured server computers,” but I don’t know what that means. Is a ‘server computer’ a machine running SQL Server—which is what I’m looking for—or can a machine be a ‘server computer’ without having anything to do with SQL Server.


If these “locally configured server computers” do turn out to be SQL Server machines is there any way to poll them to determine what flavor of SQL Server they are running? (I want the info in order to aid in the decision about whether or not to buy some kind of SQL Server multiple-user or volume deal with Microsoft.)

Large log file and unable to connect to database

I'm running SBS2008 and my SharePoint Config log is taking up 11.27Gb. I've
run into this issue before and was able to resolve it, but I cannot connect
to this database from the SQL Server Management Studio Express console.
When I open the console, I have to connect to the database by entering
\\.\pipe\mssql$microsoft##ssee\sql\query for the Server name. From there,
if I try to go to the properties of the SharePoint_Config database, I get
the following error:

TITLE: Microsoft SQL Server Management Studio Express
Cannot show requested dialog.
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
Property Owner is not available for Database
'[SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6]'. This property
may not exist for this object, or may not be retrievable due to insufficient
access rights. (Microsoft.SqlServer.Express.Smo)

Thanks for any help you can provide.

Robert Ramin

Rich Text don't work on several computers


In SharePoint 2010, we have a simple news pages. In several computers, the Rich Text Box was blocked (in gray), and can't write on it. It happends on IE 6, 7, 8 and FireFox. I thing it's a problem with JavaScript, but in some other computers work.

We checked antivirus, firewals, configuration, add site to the Trusted Sites ("Sitios de confianza" in spanish), and check several configurations.

Any suggestion?

Un saludo! Juan Segura

WPF application crashes on touch screen computers


We have an application that crashes on a touch screen application.  The error is:

value cannot be null. parameter name: owner

it occurs right after our


I searched online and tried the programs and features...turn windows features on and off and disabled the Tablet PC components.

Now our application works.

So it appears the issue is that with touch enabled you have that window that hovers allowing for text input via a stylus or finger.  That windows must cause WPF app's to crash. 

I need the users to be ablet o write (via stylus) into our text boxes.

Any ideas




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