Win 2003 Small business server with IIS being used as a web server.
Our client app can log in and run queries, but our web app when trying to log in gets the message,
'SQL server does not exsist or access denied'
The system DSN's are both sql drivers and the configuration is name pipes. Our recomended specs use TCP/IP, but when I try to change it, it craps out on me. He's opened up his firewall completely to this new box and his old box, a Win2k machine can connect using TCP/IP. This machine is in a work group.
Any suggestions on what it might be? :confused:instead of dsn, try dsn-less:
http://www.connectionstrings.com/
Showing posts with label business. Show all posts
Showing posts with label business. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
Cannot connect to the configuration database.
I am running Windoes 2003 Small Business. When trying to connect to my
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to check
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin Taylor
Martin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]
"Martin Taylor" wrote:
> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to check
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here.
> Martin Taylor
|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those two
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropriate
> answer at the bottom]
>
> "Martin Taylor" wrote:
|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOINT
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter>)
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to check
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin Taylor
Martin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]
"Martin Taylor" wrote:
> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to check
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here.
> Martin Taylor
|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those two
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropriate
> answer at the bottom]
>
> "Martin Taylor" wrote:
|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOINT
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter>)
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]
Cannot connect to the configuration database.
I am running Windoes 2003 Small Business. When trying to connect to my
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to chec
k
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin TaylorMartin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
--
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]
"Martin Taylor" wrote:
> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to ch
eck
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here
.
> Martin Taylor|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those tw
o
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropr
iate
> answer at the bottom]
>
> "Martin Taylor" wrote:
>|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
>|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOIN
T
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES
.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
>|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter> )
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to chec
k
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin TaylorMartin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
--
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]
"Martin Taylor" wrote:
> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to ch
eck
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here
.
> Martin Taylor|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those tw
o
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropr
iate
> answer at the bottom]
>
> "Martin Taylor" wrote:
>|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
>|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOIN
T
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES
.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
>|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter> )
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]
Sunday, February 19, 2012
Cannot connect to SQL Server
Recently, I installed a fresh copy of Windows Vista Business.
Then, I installed SQL Server 2005 Developer Edition.
Upon completion I get a message saying that I should update my SQL Server with SQL
Server SP1.
Good. Go to Microsoft.com, download and installed it. Update succesful.
Then I get another message telling me that I need to update to SQL Server 2005 SP2
because that one is also need it for compatibility with Windows Vista.
Good. Go again to Microsoft.com and install SP2.
Trying to connect to the server is imposible. When I try I get the folowing message:
Cannot connect to Val-PC ( the server name )
Login failed for for user 'Val-Pc\Val' (Microsoft SQL Server, Error 18456 )
Can anyone help? It would be very much appriciated.
Thanks.
What is the state of the error message ?Jens K. Suessmeyer.
http://www.sqlserver2005.de|||It seems that you are using windows authentication. check whether this user has enough permission to the server|||
For some reason, as soon as Service Pack 2 was installed successfully, the problem
was gone. I could connect to the server right away.
I understand by looking at the documentation that previous versions of SQL Server 2005 have
compatibility problems with Windows Vista and Service Pack 2 is supposed to address them.
Thanks for the help, anyway!
Thursday, February 16, 2012
Cannot connect to shared database
Using Vista, when I start Outlook 2007 I get the following message:
Business Contact Manager for Outlook could not connect to the shared database.//looking for msslbiz Do you want to work offline?
I click Continue and get the messagebox:
Business Contact Managerdatabase cannot be loaded
This action cannot be completed because Business Contact Manager cannot access the database. The database is currently stopped.
Do you want to change the database configuration?
i say Yes and the messagebox says
Microsoft Windows Search Protocol Host has stopped working.
A problem cause the program to stop working correctly. Windows will close the program and notify you if a solution is available.
I close program (no choice) and message says:
Cannot find the selected database. Verify that the network and the computer on which the databases are located are available, and that you have permission to access the database, and then retry.
Connect to computer name prompt does not work
Create new database does not work
Database creation was unsuccesful
Using MS SQL Server Management Studio Express) to connect to msslbiz
SQLServer does not allow remote connections (when trying to conect to
Note that SqlServer Express is started and running on the Vista machine, and the databases I create are available to other machines on my lan. I cannot find a way to enable remote connections on msslbiz. Any help would be greatly appreciated.
If I understand what you're trying to do, consider that SQL Express' default behavior is to disable the ability to view the server instance from another system on the LAN. You'll need to follow the instructions in http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html. Basically, this means enabling the SQLBrowser service, enabling the ports and protocols needed to share the SQLEXPRESS instance. This is generally done using the SQL Server Surface Area Configuration Tool.
hth
Subscribe to:
Posts (Atom)