Apps cannot connect to SQL after server upgrade to 2003 R2

I had a working SQL Server 2005 install based on an evaluation of Windows
Server 2003 SP2 Ent. I have several other servers running MOSS 07 and WSUS.
I upgraded the SQL server machine to 2003 R2 SP2 Ent. as the evaluation had
9 days before expiry.
However after the upgrade other machines cannot connect to the databases in
SQL, yet i can connect locally using SQL server management studio, the
databases are all intact and permissions have not been changed.
Any ideas would be gratefully received as I have my A Level coursework
stored in a a sharepoint site in one of these Databases!!!!!
AdamDid you check your Windows Firewall settings in your upgraded machine?
If it's not the problem, what's the error message exactly?
--
Ekrem Ã?nsoy
"Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
news:2997350C-2891-46FB-AC33-010DBA43C807@.microsoft.com...
>I had a working SQL Server 2005 install based on an evaluation of Windows
> Server 2003 SP2 Ent. I have several other servers running MOSS 07 and
> WSUS.
> I upgraded the SQL server machine to 2003 R2 SP2 Ent. as the evaluation
> had
> 9 days before expiry.
> However after the upgrade other machines cannot connect to the databases
> in
> SQL, yet i can connect locally using SQL server management studio, the
> databases are all intact and permissions have not been changed.
> Any ideas would be gratefully received as I have my A Level coursework
> stored in a a sharepoint site in one of these Databases!!!!!
> Adam|||windows firewall is off - i get error message when i try to access sharepoint
pages - "cannot connect to configuration database" and WSUS gives similar
error.
I can see no errrors in the application logs on the SQL server.|||Then go to SQL Server Configuration Manager and check out your protocols.
Ensure they are enabled and configured correctly.
Also, You did not mention which SQL Server Edition you have, however SQL
Server 2005 Express and Developer Editions are configured Remote Connections
disabled by default. You could check it from SQL Server Surface Area
Configuration tool.
--
Ekrem Ã?nsoy
"Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
news:654B7ED7-35C6-4854-8DBA-128757AAC45F@.microsoft.com...
> windows firewall is off - i get error message when i try to access
> sharepoint
> pages - "cannot connect to configuration database" and WSUS gives similar
> error.
> I can see no errrors in the application logs on the SQL server.|||I have SQL Server 2005 SP2 Enterprise.
All remote protocols are enabled apart from VIA as the service wont start
with it enabled.
"Ekrem Ã?nsoy" wrote:
> Then go to SQL Server Configuration Manager and check out your protocols.
> Ensure they are enabled and configured correctly.
> Also, You did not mention which SQL Server Edition you have, however SQL
> Server 2005 Express and Developer Editions are configured Remote Connections
> disabled by default. You could check it from SQL Server Surface Area
> Configuration tool.
> --
> Ekrem Ã?nsoy
>
> "Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
> news:654B7ED7-35C6-4854-8DBA-128757AAC45F@.microsoft.com...
> > windows firewall is off - i get error message when i try to access
> > sharepoint
> > pages - "cannot connect to configuration database" and WSUS gives similar
> > error.
> >
> > I can see no errrors in the application logs on the SQL server.
>

Applications without install SQL Server

Hello all
I write a program that use sqlclient to connect to SQL Server 2005 Database
so how can i run this program on a computer that SQL Server 2005 is not
installed on it
cause it's too much for the customers to install SQL Server 2005 express
edition it takes too much time and space
i think if i can take the library files and make a virtual registery on the
client PC it must works
but i don't know how to make it
please help me as soon as possible
and thanks
Use the native client redistributable and redistribute it with your
software. Download it here:
http://www.microsoft.com/downloads/d...displaylang=en
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Abood_aa" <u16990@.uwe> wrote in message news:5970150f4c114@.uwe...
> Hello all
> I write a program that use sqlclient to connect to SQL Server 2005
> Database
> so how can i run this program on a computer that SQL Server 2005 is not
> installed on it
> cause it's too much for the customers to install SQL Server 2005 express
> edition it takes too much time and space
> i think if i can take the library files and make a virtual registery on
> the
> client PC it must works
> but i don't know how to make it
> please help me as soon as possible
> and thanks

Application unable to connect Sql Server 2005

Hi,

We recently installed Sql 2005 server and it was working fine. But today one of our user reported that they could not able to connect the sql server 2005 from the application. When I checked the error log, I found the following error for every one minute. We restarted the sql service on this sql 2005 instance but still we are getting the same error.

SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed.

Could any one help us on that?

Regards,

Sankar

Hello Sankar. There appears to be several possibilities as to what is going on so i will provide the links that I think are the most relevant.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

http://support.microsoft.com/kb/247931/en-us

OJ has suggested this as a possible means for tracing it - I am not sure of your setup so it may or may not be useful.

0x80090311 error refers to "No authority could be contacted for authentication" which means the user cannot contact AD to get a ticket. I suggest turning on Kerberos logging and using Netmon to trace the authentication routes. You can find detailed info on how to troubleshoot Kerberos here.

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx

Let us know if you have any further questions or if this helps. If you do have further questions/problems please try specifying more details about your setup, e.g. are db and web server on same server? what os? what update revisions, etc.

|||

Hi, SanKar

Is your computer in a Domain? If so, it seems the problem that no KDC can be contacted. Suggest:

1) Disjoin the domain and rejoin your computer to the domain.

2) nslookup

type " <FQDN> of your client computer " see which DC returned.

3) ping <KDCname> if you know the hostname of your DC.

ping -a <ipaddress of your DC>, see whether FQDN returned.

4) Try use "SetSpn.exe" to manually register SPN, see whether it succeeds.

5) Or restart your client computer, try to use a domain account to log on, see what happens.

Good Luck!

Ming.

|||

Thanks all for your reply.

We rebooted the sql server. The error is not getting displayed after the server reboot.

Application Role with vb

I use Application role with vb.
I connect to sql server by windows authentication.
I setup each login to public role of database.
In Database , i add application role and set permission via application
role.
When VB App connect to database , it use windows authentication.
Before It connectd , i call stored procedure (sp_setapprole) to database.
It work fine except that if i use boundcolumn to control in form.
it's occure error for consequent code try to select data from table.
It warn that "permission denied".
Thanks in advanceIt's not work yet.
But i close recordset of bound column, it can select data but bound column
can not see data.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:eH6bONNeDHA.1832@.TK2MSFTNGP09.phx.gbl...
> It may be that connection pooling is resetting the connection so you
> lose the app role security context. Assuming you're using SQLOLEDB, try
> disabling connection pooling by including ';OLE DB Services=-2' in your
> connection string. For example:
> Provider=SQLOLEDB;Data Source=MyServer;Integrated Security=SSPI;Persist
> Security Info=False;;OLE DB Services=-2
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> --
> SQL FAQ links (courtesy Neil Pike):
> http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> http://www.sqlserverfaq.com
> http://www.mssqlserver.com/faq
> --
> "ton" <barameek@.inglife.co.th> wrote in message
> news:e5ydwCNeDHA.3204@.TK2MSFTNGP11.phx.gbl...
> > I use Application role with vb.
> > I connect to sql server by windows authentication.
> > I setup each login to public role of database.
> > In Database , i add application role and set permission via
> application
> > role.
> > When VB App connect to database , it use windows authentication.
> > Before It connectd , i call stored procedure (sp_setapprole) to
> database.
> > It work fine except that if i use boundcolumn to control in form.
> > it's occure error for consequent code try to select data from table.
> > It warn that "permission denied".
> >
> > Thanks in advance
> >
> >
> >
>

Application cannot connect to SQL Server 2005.

I am having a strange problem. I have an application that to connects to SQL Database in SQL Server 2005.

When I run the application with Visual Studio everything works fine but when I deploy the application on my web server and then to access the site .

I get an error :Login failed for user ''. The user is not associated with a trusted SQL Server connection.

For some reason the application is not passing the user name . I have checked the IIS and authentication is set to Integrated Windows Authentication .

My connection string is correct as well

<add name="xxxxx" connectionString="Data Source=xxxxxx;Initial Catalog=xxxx;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>

I will appreciate any kind of assistance in this matter. Thanks

check under which login your asp web page works ASPNET or Network service and create login on your SQL server for this account.

You also have to give access to your databases for this login.

If you run web page on IIS server user under which IIS server is running (or your web page specific user) requests access to SQL server.

|||

I check my sql logs and when I tried to make a connection using : UID and PWD in my connection string. The log says that

Login failed for user "<username"> [CLIENT:xxx.xxx.xxx.xxx]

below that I saw the the same user successfully logged using Management Studio saying

Login succeeded for user "<username>" [CLIENT:local machine]

I don't understand the difference. It is the same user connecting from the same local machine where sql is loaded.

Thanks

App server unable to connect to SQL Server 2000 developer edition on localhost.

Anyone encounter differences between SQL2K EE and SQL2K Dev Editon?

FAILS
--
Machine_A [App Server] <-- JDBC --> Machine_A\SQL2K_Dev_Ed..db

Error: "com.inet.tds.SQLException: Connection refused"

When app server on Machine_A attempts to connect to database on
Machine_A the conenction is refused.

SUCCEEDS
---
Machine_A [App Server] <-- JDBC --> Machine_B\SQL2K_EE..db

When app server on Machine_A attempts to connect to database on
Machine_B the conenction succeeds and the app server runs normally.

JDBC driver: com.inet.tds.TdsDriver

jdbc:inetdae7:locahost:1433

I don't believe the app server is exhausting the 10-connection max on
SQL2K developer edition (there is a 10-connection limit imposed on the
developer edition, correct?)

LBlbunet@.hotmail.com (LB) wrote in message news:<35e1fa55.0404062027.3635b8b9@.posting.google.com>...
> Anyone encounter differences between SQL2K EE and SQL2K Dev Editon?
> FAILS
> --
> Machine_A [App Server] <-- JDBC --> Machine_A\SQL2K_Dev_Ed..db
> Error: "com.inet.tds.SQLException: Connection refused"
> When app server on Machine_A attempts to connect to database on
> Machine_A the conenction is refused.
>
> SUCCEEDS
> ---
> Machine_A [App Server] <-- JDBC --> Machine_B\SQL2K_EE..db
>
> When app server on Machine_A attempts to connect to database on
> Machine_B the conenction succeeds and the app server runs normally.
> JDBC driver: com.inet.tds.TdsDriver
> jdbc:inetdae7:locahost:1433
> I don't believe the app server is exhausting the 10-connection max on
> SQL2K developer edition (there is a 10-connection limit imposed on the
> developer edition, correct?)
> LB

There is no connection limit in Developer Edition - it's Enterprise
Edition with a different licence.

I don't know exactly what "Connection refused" means, but you might
want to check the SQL Server logs for failed logins, and also test
your username/password combination with osql.exe or whatever, just to
make sure it works correctly. You could also check the authentication
modes on the two servers (Windows or Mixed), to see if they are the
same - username/password works only in Mixed mode, if that's what
you're using.

Simon|||sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0404070120.39c31661@.posting.google.com>...

... [See first post for text that appeared here]

> There is no connection limit in Developer Edition - it's Enterprise
> Edition with a different licence.
> I don't know exactly what "Connection refused" means, but you might
> want to check the SQL Server logs for failed logins, and also test
> your username/password combination with osql.exe or whatever, just to
> make sure it works correctly. You could also check the authentication
> modes on the two servers (Windows or Mixed), to see if they are the
> same - username/password works only in Mixed mode, if that's what
> you're using.
> Simon

Thanks for the feedback.

LB

Anyway to tell if this is a network issue!

A person using a vb6 windows app can not log into the server from their
machine. They get the error (you failed to connect to the SQL Server) could
be from
1.Not logged on correctly
2.Don't have rights
3.Network down
Client unable to establish connection error # -2147467259.
When the user goes to a different machine they are able to connect ok.
Thanks.
--
Paul G
Software engineer.check the client network utility and make sure it is set to tcp\ip (Not
named pipes)
also check to make sure the nic card on the client machine is set to the
same settings as the server (You probably dont want 'auto' )
Greg Jackson
PDX, Oregon|||Hi pdxJaxon, thanks for the response. Just wondering how to check if the the
nic card on the client machine is set to the same settings as the server?
Also I did a search on Google and found that if the client and server have
different versions of MDAC (Microsoft data access components) it could cause
the error, not quite sure how to find this out.
Also not familiar with the client network utility just wondering how to
access it?
--
Paul G
Software engineer.
"pdxJaxon" wrote:
> check the client network utility and make sure it is set to tcp\ip (Not
> named pipes)
> also check to make sure the nic card on the client machine is set to the
> same settings as the server (You probably dont want 'auto' )
>
> Greg Jackson
> PDX, Oregon
>
>|||Are you the one who wrote this app? Many things involved here:
1. Does the app use ODBC? ODBC driver is local on machine so it works on
the machine having ODBC setup correctly.
2. Is the server local? It may not the case but if 2 machines have
different TCP setup it could cause error.
3. The app uses trusted connection?
4. SQL on server setup with mix or SQL authentication?
There are more. It is hard to tell with this little of info.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:EBEFD042-19C5-40DE-8371-3347520EF9F2@.microsoft.com...
>A person using a vb6 windows app can not log into the server from their
> machine. They get the error (you failed to connect to the SQL Server)
> could
> be from
> 1.Not logged on correctly
> 2.Don't have rights
> 3.Network down
> Client unable to establish connection error # -2147467259.
> When the user goes to a different machine they are able to connect ok.
> Thanks.
> --
> Paul G
> Software engineer.

Anyway to tell if this is a network issue!

A person using a vb6 windows app can not log into the server from their
machine. They get the error (you failed to connect to the SQL Server) could
be from
1.Not logged on correctly
2.Don't have rights
3.Network down
Client unable to establish connection error # -2147467259.
When the user goes to a different machine they are able to connect ok.
Thanks.
Paul G
Software engineer.
check the client network utility and make sure it is set to tcp\ip (Not
named pipes)
also check to make sure the nic card on the client machine is set to the
same settings as the server (You probably dont want 'auto' )
Greg Jackson
PDX, Oregon
|||Hi pdxJaxon, thanks for the response. Just wondering how to check if the the
nic card on the client machine is set to the same settings as the server?
Also I did a search on Google and found that if the client and server have
different versions of MDAC (Microsoft data access components) it could cause
the error, not quite sure how to find this out.
Also not familiar with the client network utility just wondering how to
access it?
Paul G
Software engineer.
"pdxJaxon" wrote:

> check the client network utility and make sure it is set to tcp\ip (Not
> named pipes)
> also check to make sure the nic card on the client machine is set to the
> same settings as the server (You probably dont want 'auto' )
>
> Greg Jackson
> PDX, Oregon
>
>
|||Are you the one who wrote this app? Many things involved here:
1. Does the app use ODBC? ODBC driver is local on machine so it works on
the machine having ODBC setup correctly.
2. Is the server local? It may not the case but if 2 machines have
different TCP setup it could cause error.
3. The app uses trusted connection?
4. SQL on server setup with mix or SQL authentication?
There are more. It is hard to tell with this little of info.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:EBEFD042-19C5-40DE-8371-3347520EF9F2@.microsoft.com...
>A person using a vb6 windows app can not log into the server from their
> machine. They get the error (you failed to connect to the SQL Server)
> could
> be from
> 1.Not logged on correctly
> 2.Don't have rights
> 3.Network down
> Client unable to establish connection error # -2147467259.
> When the user goes to a different machine they are able to connect ok.
> Thanks.
> --
> Paul G
> Software engineer.

Anyway to tell if this is a network issue!

A person using a vb6 windows app can not log into the server from their
machine. They get the error (you failed to connect to the SQL Server) could
be from
1.Not logged on correctly
2.Don't have rights
3.Network down
Client unable to establish connection error # -2147467259.
When the user goes to a different machine they are able to connect ok.
Thanks.
--
Paul G
Software engineer.check the client network utility and make sure it is set to tcp\ip (Not
named pipes)
also check to make sure the nic card on the client machine is set to the
same settings as the server (You probably dont want 'auto' )
Greg Jackson
PDX, Oregon|||Hi pdxJaxon, thanks for the response. Just wondering how to check if the th
e
nic card on the client machine is set to the same settings as the server?
Also I did a search on Google and found that if the client and server have
different versions of MDAC (Microsoft data access components) it could cause
the error, not quite sure how to find this out.
Also not familiar with the client network utility just wondering how to
access it?
Paul G
Software engineer.
"pdxJaxon" wrote:

> check the client network utility and make sure it is set to tcp\ip (Not
> named pipes)
> also check to make sure the nic card on the client machine is set to the
> same settings as the server (You probably dont want 'auto' )
>
> Greg Jackson
> PDX, Oregon
>
>|||Are you the one who wrote this app? Many things involved here:
1. Does the app use ODBC? ODBC driver is local on machine so it works on
the machine having ODBC setup correctly.
2. Is the server local? It may not the case but if 2 machines have
different TCP setup it could cause error.
3. The app uses trusted connection?
4. SQL on server setup with mix or SQL authentication?
There are more. It is hard to tell with this little of info.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:EBEFD042-19C5-40DE-8371-3347520EF9F2@.microsoft.com...
>A person using a vb6 windows app can not log into the server from their
> machine. They get the error (you failed to connect to the SQL Server)
> could
> be from
> 1.Not logged on correctly
> 2.Don't have rights
> 3.Network down
> Client unable to establish connection error # -2147467259.
> When the user goes to a different machine they are able to connect ok.
> Thanks.
> --
> Paul G
> Software engineer.

Anytime I connect to an Excel file from SSIS05, I start getting endemic system.outofmemoryexcept

This is my error text... how do I get this nonsense to stop?!

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

Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft Visual Studio)

Program Location:

at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(Char value)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BufferTextWriter.Write(Char ch)
at System.IO.TextWriter.Write(Char[] buffer, Int32 index, Int32 count)
at System.IO.TextWriter.Write(Char[] buffer)
at System.IO.TextWriter.Write(String value)
at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializePackage(IDesignerSerializationManager manager, Package package, TextWriter textWriter)
at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializeComponent(IDesignerSerializationManager manager, IComponent component, Object serializationStream)
at Microsoft.DataWarehouse.Serialization.DesignerComponentSerializer.Serialize(IDesignerSerializationManager manager, Object value)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Serialize()
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BaseDesignerLoader.Flush(Boolean forceful)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BaseDesignerLoader.Flush()
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseContainerManager.OnBeforeSave(UInt32 docCookie)

Can we get some more information? Is this when you connect to any Excel file, or to one particular one?

If this only happens when connecting to a specific file, how much data is being returned?

Is there any information in task manager that you can give us to help? How much memory is available, or in use? Do you see memory usage spiking in a particular process when connecting to Excel?

Donald