Error: Data source name not found and No default driver specified

Hello all,
I have an application which was written in VB6. I used
DSNless connection for the odbc connection to access sql 8.0. The
application works fine on one machine and when I try to run the appl.
on another machine I got this error. Any idea why' Here is my
connection string:
DSNName = "Driver={SQL Server};" & _
"Server=dummy;" & _
"Database=sql_data;" & _
"Uid=crystal"
The user id does not require a password.. Thank you.
SherryThis is a question for a VB group, not a SQL server group, but it sounds
like your DSNName is empty. Are you getting this value from an INI file,
the registry, or is it hardcoded in your app? You will most likely find
that this value is missing, wherever you define it.
Put in a message box that shows DSNName just prior to creating the
connection, and confirm that it is actually populated (I don't think it is).
<sunpalozzi@.gmail.com> wrote in message
news:1138811193.427214.282490@.g43g2000cwa.googlegroups.com...
> Hello all,
> I have an application which was written in VB6. I used
> DSNless connection for the odbc connection to access sql 8.0. The
> application works fine on one machine and when I try to run the appl.
> on another machine I got this error. Any idea why' Here is my
> connection string:
> DSNName = "Driver={SQL Server};" & _
> "Server=dummy;" & _
> "Database=sql_data;" & _
> "Uid=crystal"
> The user id does not require a password.. Thank you.
> Sherry
>|||Maybe the other machine doesn't have MDAC installed?
http://www.aspfaq.com/2057
Once you have the most recent version installed, an OLEDB connection string
will be better in most cases:
ConnectionString = _
"Provider=SQLOLEDB.1; " & _
"Data Source=dummy; " & _
"Initial Catalog=sql_data; " & _
"User ID=crystal; " & _
"Password="
<sunpalozzi@.gmail.com> wrote in message
news:1138811193.427214.282490@.g43g2000cwa.googlegroups.com...
> Hello all,
> I have an application which was written in VB6. I used
> DSNless connection for the odbc connection to access sql 8.0. The
> application works fine on one machine and when I try to run the appl.
> on another machine I got this error. Any idea why' Here is my
> connection string:
> DSNName = "Driver={SQL Server};" & _
> "Server=dummy;" & _
> "Database=sql_data;" & _
> "Uid=crystal"
> The user id does not require a password.. Thank you.
> Sherry
>|||thank you for all replies.. I did post in the vb group as well.. The
wire part is the same application is work on one pc but not the
another... I will try to find out if there a MDAC install on the
problem pc.. thanks.
Sherry

Error: 26 - Error Locating Server/Instance Specified - (My hosting company says it's in my conn

Hi All...

I am trying to move my site (incomplete) for testing and I am finding that the Db connection process to be

the most difficult, well back to my problem. I can't seem to get past this error and am frustrated with overall

connectivity problems. Please help!!!

===================================================================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Now you all must admit that, if your somewhat new to this databasing, It's a ***.

The source for my application is Visual Web Designer 2005 Express

It is an ASP.Net driven site with membership roles and all the good stuff.

the latest theory is that I need to change the provider config in the web.config file from AspNetSqlProvider

to something else. Most of my complications and frustrations come from GoDaddy and no access to the

shared server (understandibly).

I hope I gave enough info for help and not too much..

Dave

Please check this blog for solutions:

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

sql

error: 26 - Error Locating Server/Instance Specified

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does anyone know what could be wrong ?

Check if the local/remote connections have been enabled for ur instamce....Launcg SQL Server Surface Area configuration...Connections and services...Check Local and Network connections.....|||Looks like you are trying to connect a remote named instance. To make it work, SQL Browser on the remote server must be enabled, UDP port 1434 should be put into exception if firewall presents.|||

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

|||

Naeem Sheikh wrote:

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

Thnanks i wonder firewall is blocking my tcp/ip port and now i am connecting to the server|||Yes. It that is necessary.

error: 26 - Error Locating Server/Instance Specified

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does anyone know what could be wrong ?

Check if the local/remote connections have been enabled for ur instamce....Launcg SQL Server Surface Area configuration...Connections and services...Check Local and Network connections.....|||Looks like you are trying to connect a remote named instance. To make it work, SQL Browser on the remote server must be enabled, UDP port 1434 should be put into exception if firewall presents.|||

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

|||

Naeem Sheikh wrote:

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

Thnanks i wonder firewall is blocking my tcp/ip port and now i am connecting to the server|||Yes. It that is necessary.

error: 26 - Error Locating Server/Instance Specified

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does anyone know what could be wrong ?

Check if the local/remote connections have been enabled for ur instamce....Launcg SQL Server Surface Area configuration...Connections and services...Check Local and Network connections.....|||Looks like you are trying to connect a remote named instance. To make it work, SQL Browser on the remote server must be enabled, UDP port 1434 should be put into exception if firewall presents.|||

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

|||

Naeem Sheikh wrote:

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

Thnanks i wonder firewall is blocking my tcp/ip port and now i am connecting to the server|||Yes. It that is necessary.

error: 26 - Error Locating Server/Instance Specified

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does anyone know what could be wrong ?

Check if the local/remote connections have been enabled for ur instamce....Launcg SQL Server Surface Area configuration...Connections and services...Check Local and Network connections.....|||Looks like you are trying to connect a remote named instance. To make it work, SQL Browser on the remote server must be enabled, UDP port 1434 should be put into exception if firewall presents.|||

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

|||

Naeem Sheikh wrote:

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

Thnanks i wonder firewall is blocking my tcp/ip port and now i am connecting to the server|||Yes. It that is necessary.

error: 26 - error locating server/instance specified

My machine is WinXP with SP2. I installed SQL Server 2005 Developer
Edition on my machine last week, and I could bring up the Microsoft
SQL Server Management Studio fine, no error.
Today in Microsoft SQL Server Management Studio when I tried to
connect to machinename\SQL2005 (the SQL 2005 instance), I got the
error:
"An error has occured while establishing a connection to the server.
when connecting to sql server 2005, this failure may be caused by the
fact that under the default settings sql server does not allow remote
connections. (provider: sql network interfaces, error: 26 - error
locating server/instance specified)(microsoft sql server)"
But, I am not trying to connect to it remotely, the SQL Server 2005 is
on my machine.
In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
Configuration for Services and connections
"Local and remote connections" is not selected.
How can I fix this problem ?
Thank you.
Never mind.
On the "Server name", i click on Browse more and select the instance
from there, I guess the machinename is different today than last week.
So, I selected that one and now it works.
THanks
On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> My machine is WinXP with SP2. I installed SQL Server 2005 Developer
> Edition on my machine last week, and I could bring up the Microsoft
> SQL Server Management Studio fine, no error.
> Today in Microsoft SQL Server Management Studio when I tried to
> connect to machinename\SQL2005 (the SQL 2005 instance), I got the
> error:
> "An error has occured while establishing a connection to the server.
> when connecting to sql server 2005, this failure may be caused by the
> fact that under the default settings sql server does not allow remote
> connections. (provider: sql network interfaces, error: 26 - error
> locating server/instance specified)(microsoft sql server)"
> But, I am not trying to connect to it remotely, the SQL Server 2005 is
> on my machine.
> In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
> Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
> Configuration for Services and connections
> "Local and remote connections" is not selected.
> How can I fix this problem ?
> Thank you.
|||On Jun 10, 1:27 pm, fiefie.ni...@.gmail.com wrote:[vbcol=seagreen]
> Never mind.
> On the "Server name", i click on Browse more and select the instance
> from there, I guess the machinename is different today than last week.
> So, I selected that one and now it works.
> THanks
> On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
>
>
I get the same error. Please advise.
sql

error: 26 - Error Locating Server/Instance Specified

Hi

I seem to have a quite common problem. I’ve search forums and blogs both on Microsoft and outside but even though I find many people that have similar problems. After migrating from XP to Vista I can’t seem to solve the problem. I can’t seem to get by Windows Form application based on framework 2.0 to connect to my locally stored SQL Server 2005 Express database. The application has not changed and the environment (apart from the operating system) hasn’t changed either. No matter what I try the problem persists.

The thing that confuses me the most is that I within Visual Studio 2005 can preview data in the data sources tab. In my understanding, both uses the same connection string but I find it possible that the user might differ but I don’t understand why is should.

From my point of view (and might of course be wrong) these things should not be the source of the problem:

· The firewall, since that has been turned off

· The connection string, since that actually work when performing a preview data

· The remote settings, since the server and the client is on the same machine

· The SQL Browser, since I tried connecting using a TCP/IP connection with the same results

Possible problems:

· SQL User access, if the user when performing preview is for some reason not the same as when the application runs

· A Vista problem of some sort

I’ve read basically everything I’ve been able to find on the issue but even though the symptoms fit the solutions don’t solve the problem. This problem has been haunting me for weeks now and I’m really out of ideas?

Here is a listing of things I’ve tried without success:

· The remote settings in the SQL Server Surface Area Configuration has been turned on even though I don’t understand to what end since the server and client in this case reside on the same physical machine. However this did allow me to try connections using TCP/IP. I did restart both the services and the computer to be sure.

· Connections using TCP/IP where the connection string supply contain tcp:<ip>,<port>

· Different exceptions in the firewall, both on port level (for UDP and TCP) and on application level (sqlserver.exe and sqlbrowser.exe). The dynamic port setting has was changed during this test to a static port setting.

· A number of variants of the connection strings (e.g. using ./sqlexpress instead of <machine_name>/sqlexpress)

· All the error logs (Event logs, SQL ERRORLOGS and firewall log while it was turned on) have been checked and the only reoccurring message is a warning message from the SQL Browser: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.

The server and the client reside on the same machine.

[1] These are the specific CLIENT side settings:
1. Connection string: Data Source=.\SQLEXPRESS;Initial Catalog=Products;Integrated Security=True
2. Full error message: An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I can ping the server
3. Client and server reside on the same machine
4. Yes I can ping the machine
5. Haven’t tried
6. SQL Server Management Studio Express works, using Visual Studio 2005 works but the applications built by VS2005 doesn’t work.
7. N/A (Client and server reside on the same machine)
8.
9. No alias used
10. No encryption used.

[2] These are the specific SERVER side settings:
1. SQL Server 2005 Express SP2
2. Se above
3. Protocols enabled Shared Memory, TCPIP and Named Pipes
4. Yes, there are not errors in the ERRORLOG
5. Yes the SQL Browser is enabled and active and must work at least in some aspects since the preview data works
6. Currently running as default: Network Service
7. The firewall is turned off entirely
8. The firewall is turned off entirely

[2a] Visual Studio 2005 Team Edition for Developers

[3]
1. Vista Business
2. No antivirus installed at this point.

Hope for some help.

Regards Malin

Hi again

I've started using connecting via TCP to my old SQL Server Express server residing on a XP machine and suprise, it works perfectly without any problems what so ever! Apart the operating system I really can't find any differences in the settnigs. So my guess is that the problem must be somewhere in between Vista and my SQL server.

So has anybody else had any experience with Vista and SQL Server Express? Any suggestions are welcome!

Regards Malin

error: 26 - Error Locating Server/Instance Specified

Hi

I have setup the membership schema on a hosted server using the asp_regsql.exe tool fine. I have setup roles/memberships using the website adminitraion tool and i have checked that its all being entered into my hosted MSSQL server. I have also setup my web.config file to point to the hosted server and all seems to be connecting ok! When i test/debug my project locally (using the F5 key), my login box works fine!

How ever, i have now uploaded my project to my hosted server. If i put an incorrect login, then i get the usual 'Your login attempt was not successful. Please try again.' - So i know its connecting to the right database. How ever, when i enter the correct login details, i get the following error:

An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may becaused by the fact that under the default settings SQL Server does notallow remote connections. (provider: SQL Network Interfaces, error: 26- Error Locating Server/Instance Specified)

...if its connecting to the same database fine when i test it from my local machine, why will it not work when i test it from my hosted server?

thanks

Hi

I've got it working now, how ever the problem seems to be somthing to with trying to access a page which is not in the root. I placed a new folder called 'admin' into my root folder. Inside the admin folder i placed a login.aspx and a default.aspx page.

In my web.config i placed:

<authentication mode="Forms">
<forms loginUrl="4dm1n/login.aspx" />
</authentication>

When logging on using this folder system is when the error occurs!

Any ideas what i need to change in order to get the scope right?

|||

found the problem - I hadn't declared the roleManager provider, eg

<roleManager enabled="true" defaultProvider="CustomizedRoleProvider">
<providers>
<add name="CustomizedRoleProvider"
type="System.Web.Security.SqlRoleProvider"
connectionStringName="BVDB" />
</providers>
</roleManager>

duh!

error: 26 - error locating server/instance specified

My machine is WinXP with SP2. I installed SQL Server 2005 Developer
Edition on my machine last week, and I could bring up the Microsoft
SQL Server Management Studio fine, no error.
Today in Microsoft SQL Server Management Studio when I tried to
connect to machinename\SQL2005 (the SQL 2005 instance), I got the
error:
"An error has occured while establishing a connection to the server.
when connecting to sql server 2005, this failure may be caused by the
fact that under the default settings sql server does not allow remote
connections. (provider: sql network interfaces, error: 26 - error
locating server/instance specified)(microsoft sql server)"
But, I am not trying to connect to it remotely, the SQL Server 2005 is
on my machine.
In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
Configuration for Services and connections
"Local and remote connections" is not selected.
How can I fix this problem ?
Thank you.Never mind.
On the "Server name", i click on Browse more and select the instance
from there, I guess the machinename is different today than last week.
So, I selected that one and now it works.
THanks
On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> My machine is WinXP with SP2. I installed SQL Server 2005 Developer
> Edition on my machine last week, and I could bring up the Microsoft
> SQL Server Management Studio fine, no error.
> Today in Microsoft SQL Server Management Studio when I tried to
> connect to machinename\SQL2005 (the SQL 2005 instance), I got the
> error:
> "An error has occured while establishing a connection to the server.
> when connecting to sql server 2005, this failure may be caused by the
> fact that under the default settings sql server does not allow remote
> connections. (provider: sql network interfaces, error: 26 - error
> locating server/instance specified)(microsoft sql server)"
> But, I am not trying to connect to it remotely, the SQL Server 2005 is
> on my machine.
> In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
> Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
> Configuration for Services and connections
> "Local and remote connections" is not selected.
> How can I fix this problem ?
> Thank you.|||On Jun 10, 1:27 pm, fiefie.ni...@.gmail.com wrote:[vbcol=seagreen]
> Never mind.
> On the "Server name", i click on Browse more and select the instance
> from there, I guess the machinename is different today than last week.
> So, I selected that one and now it works.
> THanks
> On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
>
>
>
>
I get the same error. Please advise.

error: 26 - error locating server/instance specified

My machine is WinXP with SP2. I installed SQL Server 2005 Developer
Edition on my machine last week, and I could bring up the Microsoft
SQL Server Management Studio fine, no error.
Today in Microsoft SQL Server Management Studio when I tried to
connect to machinename\SQL2005 (the SQL 2005 instance), I got the
error:
"An error has occured while establishing a connection to the server.
when connecting to sql server 2005, this failure may be caused by the
fact that under the default settings sql server does not allow remote
connections. (provider: sql network interfaces, error: 26 - error
locating server/instance specified)(microsoft sql server)"
But, I am not trying to connect to it remotely, the SQL Server 2005 is
on my machine.
In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
Configuration for Services and connections
"Local and remote connections" is not selected.
How can I fix this problem ?
Thank you.Never mind.
On the "Server name", i click on Browse more and select the instance
from there, I guess the machinename is different today than last week.
So, I selected that one and now it works.
THanks
On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> My machine is WinXP with SP2. I installed SQL Server 2005 Developer
> Edition on my machine last week, and I could bring up the Microsoft
> SQL Server Management Studio fine, no error.
> Today in Microsoft SQL Server Management Studio when I tried to
> connect to machinename\SQL2005 (the SQL 2005 instance), I got the
> error:
> "An error has occured while establishing a connection to the server.
> when connecting to sql server 2005, this failure may be caused by the
> fact that under the default settings sql server does not allow remote
> connections. (provider: sql network interfaces, error: 26 - error
> locating server/instance specified)(microsoft sql server)"
> But, I am not trying to connect to it remotely, the SQL Server 2005 is
> on my machine.
> In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
> Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
> Configuration for Services and connections
> "Local and remote connections" is not selected.
> How can I fix this problem ?
> Thank you.|||On Jun 10, 1:27 pm, fiefie.ni...@.gmail.com wrote:
> Never mind.
> On the "Server name", i click on Browse more and select the instance
> from there, I guess the machinename is different today than last week.
> So, I selected that one and now it works.
> THanks
> On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> > My machine is WinXP with SP2. I installedSQLServer 2005 Developer
> > Edition on my machine last week, and I could bring up the Microsoft
> >SQLServer Management Studio fine, noerror.
> > Today in MicrosoftSQLServer Management Studio when I tried to
> > connect to machinename\SQL2005 (theSQL2005 instance), I got the
> >error:
> > "Anerrorhas occured while establishing a connection to the server.
> > when connecting tosqlserver 2005, this failure may be caused by the
> > fact that under the default settingssqlserver does not allow remote
> > connections. (provider:sqlnetwork interfaces,error:26-error
> > locating server/instance specified)(microsoftsqlserver)"
> > But, I am not trying to connect to it remotely, theSQLServer 2005 is
> > on my machine.
> > In the Start >> Programs >> MicrosoftSQLServer 2005 >> Configuration
> > Tools >>SQLServer 2005 Surface Area Configuration >> Surface Area
> > Configuration for Services and connections
> > "Local and remote connections" is not selected.
> > How can I fix this problem ?
> > Thank you.
I get the same error. Please advise.

Error: "no report servers were found on the specified machine"

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

Are you using the config tool to manage a remote RS server?|||I'm getting this too but it's on the local box.|||

NoEgo wrote:

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

|||

Hello there, is got solved for me by running SQL Setup and selecting a new component (Reporting Services). See my post at http://blogs.msdn.com/dszabo/archive/2007/04/10/quot-no-report-servers-were-found-on-the-specified-machine-quot.aspx for more details.

David

Error: "no report servers were found on the specified machine"

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

Are you using the config tool to manage a remote RS server?|||I'm getting this too but it's on the local box.|||

NoEgo wrote:

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

|||

Hello there, is got solved for me by running SQL Setup and selecting a new component (Reporting Services). See my post at http://blogs.msdn.com/dszabo/archive/2007/04/10/quot-no-report-servers-were-found-on-the-specified-machine-quot.aspx for more details.

David

Error: "no report servers were found on the specified machine"

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

Are you using the config tool to manage a remote RS server?|||I'm getting this too but it's on the local box.|||

NoEgo wrote:

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

|||

Hello there, is got solved for me by running SQL Setup and selecting a new component (Reporting Services). See my post at http://blogs.msdn.com/dszabo/archive/2007/04/10/quot-no-report-servers-were-found-on-the-specified-machine-quot.aspx for more details.

David

error.log invalid protocol specified

I get the entries shown below in my error.log of
an msde on WinXP home.
Where does this Invalid Protocol specified for a ?
come from ?
Should i run svrnetcn.exe to configure protocols ?
Is it true, that I have to install MSDE with
DISABLENETWORKPROTOCOL=0 set to access it from
a remote site ?
2004-04-29 11:54:05.34 server Using 'SSNETLIB.DLL'
version '8.0.760'.
2004-04-29 11:54:05.34 server Invalid Protocol
specified for a
??4? instance: ?.
2004-04-29 11:54:05.34 server Invalid Protocol
specified for a
??t? instance: ?c??t?.
2004-04-29 11:54:05.34 server Invalid Protocol
specified for a
??t?y, Winsock Proxy instance: ?.
2004-04-29 11:54:05.34 spid5 Starting up
database 'model'.
2004-04-29 11:54:05.63 server SQL server listening on
192.168.1.34:
1433.
2004-04-29 11:54:05.63 server SQL server listening on
127.0.0.1:
1433.
2004-04-29 11:54:05.63 server SuperSocket Info: Bind
failed on TCP
port 1433.
2004-04-29 11:54:05.64 server SQL server listening on
192.168.1.34:
1433.
2004-04-29 11:54:05.64 server SQL server listening on
127.0.0.1:
1433.
..
hi Dominique,
"Dominique" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:a26601c434eb$a425b4f0$a601280a@.phx.gbl...
> I get the entries shown below in my error.log of
> an msde on WinXP home.
> Where does this Invalid Protocol specified for a ?
> come from ?
> Should i run svrnetcn.exe to configure protocols ?
> Is it true, that I have to install MSDE with
> DISABLENETWORKPROTOCOL=0 set to access it from
> a remote site ?
MSDE sp3a and MSDE release A install by default disabling all network
protocols in order to protect the installed instance from malicious external
attacks..
if you want your instance to be accessible from remote client you have to
enable network protocols at install time, via the DISABLENETWORKPROTOCOL=0
command line parameter or anabling them after install via Server Network
Utility (svrnetcn.exe)...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Error while loading code module

I have created a custom assembly and referenced it. The class can be
instantiated, so I have specified the class and instance name.
So, when I build the solution, the compiler returns these errors:
Error while loading code module: â'XXX, Version=Y.Y.YYYY.YYYYY
Culture=neutral, PublicKeyToken=nullâ'. Details: File or assembly name XXX, or
one of its dependencies, was not found.
Should there be a directory that this assembly be placed? As a test, I
placed the .dll in the GAC and experieced the same error.
Any help would be appreciated.
Thanks - JMLYes, you must place dll file in
\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
directory
Regards
"AgentSmith" <AgentSmith@.discussions.microsoft.com> escribió en el mensaje
news:754CB514-27F9-40F3-82EE-6D46D143DB05@.microsoft.com...
> I have created a custom assembly and referenced it. The class can be
> instantiated, so I have specified the class and instance name.
> So, when I build the solution, the compiler returns these errors:
> Error while loading code module: 'XXX, Version=Y.Y.YYYY.YYYYY
> Culture=neutral, PublicKeyToken=null'. Details: File or assembly name XXX,
or
> one of its dependencies, was not found.
> Should there be a directory that this assembly be placed? As a test, I
> placed the .dll in the GAC and experieced the same error.
> Any help would be appreciated.
> Thanks - JML
>|||What if the report server is not on your machine? Should I just create the
directory?
"plmartinez" wrote:
> Yes, you must place dll file in
> \Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
> directory
> Regards
> "AgentSmith" <AgentSmith@.discussions.microsoft.com> escribió en el mensaje
> news:754CB514-27F9-40F3-82EE-6D46D143DB05@.microsoft.com...
> > I have created a custom assembly and referenced it. The class can be
> > instantiated, so I have specified the class and instance name.
> >
> > So, when I build the solution, the compiler returns these errors:
> >
> > Error while loading code module: 'XXX, Version=Y.Y.YYYY.YYYYY
> > Culture=neutral, PublicKeyToken=null'. Details: File or assembly name XXX,
> or
> > one of its dependencies, was not found.
> >
> > Should there be a directory that this assembly be placed? As a test, I
> > placed the .dll in the GAC and experieced the same error.
> >
> > Any help would be appreciated.
> >
> > Thanks - JML
> >
>
>