Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.








Sponsored Links:

Related Messages:
Cannot Connect To Server Through Ssms - Cannot Generate Sspi Context
Hi,
 
I have gone through so many kb articles to understanding the problem, but no luck as yet.
 
Here is the situation:
 
I have two dev servers : Server A and Server B.  Both are set up in an identical fashion.  Windows 2003 sp2, Sql Server 2005 sp1 Developer Edition, both are on the same domain, Both have all the three protocols enabled: Shared Memory, Tcpip, and Named Pipes in that order.  I can ping both servers, and telnet using the default port.  Both have only default instances.  Both use the same domain user account for sql service.  Both have the error in the log saying that spn could not be registered so authentication may fall back to NTLM.
 
Here is the issue:  When I try to register Server A specifying tcp-ip connection,  I am successful and I can see that the authentication is NTLM -  is as expected.  since the spn registration did not happen and since the sqlservice account is not a domain admin, the authentication used NTLM over tcp-ip.  However,  I try to register Server B specifying tcpip,  I get a cannot generate sspi context error.  Why did the authentication not fall back to NTLM as in Server A?  From what I read in the KB articles, I asked our network admin to check up the spn, but he assures me that spn were never manually registered.
 
Can somebody throw more light on this issue?
 
Thanks
KRSE

View Replies !   View Related
SSPI Error '-2147467259 (80004005) Cannot Generate SSPI Context
We are runnig Windows server 2003 R2 and SQL Server 2005 Standard on the same computer.
 
We have workstations that log into our domain with Windows Authentication.  The software loads just fine and then later up pops the error noted above.
 
Any help you can give me is greatly appreciated.
 
Thanks
Paul

View Replies !   View Related
Cannot Generate SSPI Context. (Microsoft SQL Server, Error: 0)
Hi,

I am working on sql server 2005 .

when I am trying to connect to server:

 

following error is occuring:

 

TITLE: Connect to Server
------------------------------

Cannot connect to servername

------------------------------
ADDITIONAL INFORMATION:

Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)

 

Could any one help What might be the problem ? for this ?

 

Thanks,

Ramki

View Replies !   View Related
Please - OLE DB Provider For SQL Server (0x80004005) Cannot Generate SSPI Context
Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.

View Replies !   View Related
Connecting To SQL Server 2005 Using Windows Auth/Cannot Generate SSPI Context Error
Hi-I have a program that I am developing on a laptop, then deploying it on a server.I have the prgram running passing a username and PW in the connection object, but like the idea of using windows authentication MUCH better.I just joined the domain, so I am domain/me for example.If I log into the server, and look at securities, logins and added domain/me to the logins.I then try and set up a sql connection via both visual studio, and sql server magt studio, and get the dreaded "Cannot generate SSPI context" error. Anyone else have this problem? SHOULD V.S. be using domain/me to connect?  TIA dan 

View Replies !   View Related
Cannot Generate SSPI Context
I was trying out the Building an End-to-End Application (VB.Net) exercises on Web Matrix Guided Tour and encountered the mentioned errors. Please help. Thanks.

The code is as follows :

<%@ Page Language="VB" Debug="true"%>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

Sub Page_Load(Sender As Object, E As EventArgs)
Welcome.Text = "Hello, " + User.Identity.Name
If Not Page.IsPostBack Then

' Databind the master grid on the first request only
' (viewstate will restore these values on subsequent postbacks).

MasterGrid.SelectedIndex = 0
BindMasterGrid()
BindDetailGrid()

End If

End Sub

Sub MasterGrid_Select(Sender As Object, E As EventArgs)
BindDetailGrid()
End Sub

Sub MasterGrid_Page(Sender As Object, E As DataGridPageChangedEventArgs)

If MasterGrid.SelectedIndex <> -1 Then

' unset the selection, details view
MasterGrid.SelectedIndex = -1
BindDetailGrid()

End If

MasterGrid.CurrentPageIndex = e.NewPageIndex
BindMasterGrid()

End Sub

Sub BindMasterGrid()

' TODO: Update the ConnectionString and CommandText values for your application
Dim ConnectionString As String = "server='WRPBI'; user id='sa'; password='sa';database=MatrixOrders;Integrated Security=SSPI"

Dim CommandText As String = "select OrderID, OrderDate, CustomerName from Orders"

Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlDataAdapter(CommandText, myConnection)

Dim ds As New DataSet()
myCommand.Fill(ds)

MasterGrid.DataSource = ds
MasterGrid.DataBind()

End Sub

Sub BindDetailGrid()

' get the filter value from the master Grid's DataKeys collection
If MasterGrid.SelectedIndex <> -1 Then

' TODO: update the ConnectionString value for your application
Dim ConnectionString As String = "server='WRPBI'; user id='sa'; password='sa';database=MatrixOrders;Integrated Security=SSPI"

' TODO: update the CommandText value for your application
Dim filterValue As String = CStr(MasterGrid.DataKeys(MasterGrid.SelectedIndex)).Replace("'", "''")
Dim CommandText As String = "select OrderDetailID, ProductName, Quantity, UnitPrice from OrderDetails where OrderID = '" & filterValue & "'"

Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(CommandText, myConnection)

myConnection.Open()

DetailsGrid.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

End If

DetailsGrid.DataBind()

End Sub

</script>


And this is the compilation error :

Cannot generate SSPI context.
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: Cannot generate SSPI context.

Source Error:


Line 49:
Line 50: Dim ds As New DataSet()
Line 51: myCommand.Fill(ds)
Line 52:
Line 53: MasterGrid.DataSource = ds


Source File: C:WorksWebWISHDefault.aspx Line: 51

Stack Trace:


[SqlException: Cannot generate SSPI context.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +311
System.Data.SqlClient.SqlConnection.Open() +383
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.Default_aspx.BindMasterGrid() in C:WorksWebWISHDefault.aspx:51
ASP.Default_aspx.Page_Load(Object Sender, EventArgs E) in C:WorksWebWISHDefault.aspx:14
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731

View Replies !   View Related
Cannot Generate SSPI Context
HiMy company uses a Windows 2000 server with MS SQL Server 2000.We have many clients with administrative software that use the MS SQLserver, the problem is that we experimented randomly the error"Cannot Generate SSPI Context" and the only way to work with DB is logout the client.I'm looking the MS Technical sheet but there's no resolving hints thatcan help.Anyone has a similar problem ?Thanks.

View Replies !   View Related
Cannot Generate SSPI Context
Hello all,Back-end: SS2000 SP2 + NT4Front-end: A97 + XPWe are currently trying to add a Domain Server to our network. We added ourSQL Server to the domain and added a client too. Everything is workingfine... for maybe 20 or 30 minutes. Then the client generates this error:-----------------Connection failed:SQLState: 'S1000'SQL Server Error: 0[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context-----------------Then we have to logout and login again. There is many KB on this error. Wetry almost everthing without success. Now, the team is questionning the SQLServer software config. Making it, hypotheticaly, to close a previouslyopened connection and prevent a new one to being created. Both named pipesand TCP/IP protocols are enabled in SS config.So my main question is: Could this error be related to SS config/setup?For more information about the error, here:http://support.microsoft.com/kb/811889/en-usyou can read:------------------The SQL Server driver on a client computer uses integrated security to usethe Windows security token of the user account to successfully connect to acomputer that is running SQL Server. The Windows security token is delegatedfrom the client to the computer that is running SQL Server. The SQL Serverdriver performs this delegation when the user's security token is delegatedfrom one computer to another by using one of the following configurations:. NTLM over Named Pipes (not using Security Support Provider Interface[SSPI]). NTLM over TCP/IP sockets with SSPI. Kerberos over TCP/IP sockets with SSPISecurity Support Provider Interface (SSPI) is a set of Windows APIs thatpermits delegation and mutual authentication over any generic data transportlayer, such as TCP/IP sockets. Therefore, SSPI permits a computer that isrunning a Windows operating system to securely delegate a user securitytoken from one computer to another over any transport layer that cantransmit raw bytes of data.The "Cannot generate SSPI context" error is generated when SSPI usesKerberos to delegate over TCP/IP and Kerberos cannot complete the necessaryoperations to successfully delegate the user security token to thedestination computer that is running SQL Server.-------------------Many thanks for your feedback.Yannick

View Replies !   View Related
Cannot Generate Sspi Context
I get "cannot generate sspi context" when creating a "New SQL Server Registration" on a SQL Server 2000 instance.

Note: there are three instances and I can connect to the other two? The services for the instances were set to start with a particular account and if I change the problem instance startup account to the system account, all is well.

I need to start all instances with a domain user, so that I can set up SQL Mail, Query Analyzer Debugging, etc.

Thanks for your help.

View Replies !   View Related
Cannot Generate SSPI Context
I am having a problem with connecting with my SQL Server with Enterprise Manager. I can work fine for awhile and then for no apparent reason I loose the connection and get the following error:

Connection failed:
Cannot generate SSPI context


I have to restart my work station and then it works for awhile and then it happens again.

Please help!

View Replies !   View Related
Cannot Generate SSPI Context
All of a sudden I cannot connect to sql server from Visual Studio. Nor I can't conenct to Sql server through IIS and it gives me the same error saying "Login failed: Cannot Generate SSPI Context". Lots of my development projects got stuck because of the SSPI Issue. I know there was a network upgrade from Windows NT (users) to Active directory. I can only access the sql server from the host machine.if someone can guide or give me a quick run down on things to look for that would be wonderful.

View Replies !   View Related
Cannot Generate SSPI Context
I'm signing into a sqlexpress 2005 local server using windows integration and it fails with a "Cannot generate SSPI context". After 2 years of working with this, it just started to happen after I installed a new piece of software to test.  My colleague thinks it hosed our domain names. I've read all the articles and most of them have to do with a non-local server.  I also read that this is caused with TCP/IP so I disabled it for sqlexpress and tried again. Then I get "An error has occurred while establishing a connection to the server. When connecting to the sql server 2005, this failure may be caused by the fact that under the default settings sql server does not allow remote connections."  I know I have remote enabled so that isn't true. If it uses VIA, "Login failed for user '(null)'. Not a trusted sql connection" or something like that. Anyway, I think something is hosed in my domain and my colleague fixed it by downloading some xp tool that he can't remember where it came from. Any chance anyone else knows about this tool?

View Replies !   View Related
Cannot Generate SSPI Context
I have a SQL Server 2000 in a specific W2K server, that belongs to a domain that is administered by a W2003 server.

There is a client that has a new computer with WXP in the same domain. It used to have an old machine with W2K pro.  and with the same user it worked OK.

When accesing SQL from the client with an Office2003 application via ODBC with windows authentication, after several minutes working OK, suddenly it gets this message:

Conection error. SQL state: S1000

Cannot generate SSPI context.

In the client I have executed cliconfg.exe and created a piped name protocol, but still it won't work.

View Replies !   View Related
Cannot Generate Sspi Context
Howdy,

Firstly, I have read through so much information on this, that my eyes are starting to bleed and I am right at the end of my rope with it all..

 

This issue has only started showing since I re-installed my dev box, so my server has not changed at all..

 

Server is 2003 with SQL 2005.

 

Dev box is

Vista (Ultimate)

Visual Studio Pro 2005..

 

A quick but painful solution is for me to log out of my box and then back in, but this is unworkable at times... about the only difference I can think of this install from the last is that now I have also installed SQLExpress on the dev box. I have gone into services and made sure that the service does not start auto. I have connection to the server and am running as administrator on both until such time as I can sort this out, but the error still occurs.

 

Authentication for the dbase is both windows and credential.

 

Can someone please give me a stratight out solution for this.

 

Cheers

 

 

View Replies !   View Related
Cannot Generate SSPI Context
Win Server 2003
SQL Server 2000 SP4
SharePoint Server

Win Server 2000 (Domain Controller / Active Drectory)

Clients: Win XP / Access XP

I have two clients that can access the SQL Server and one that can not.  All clients can access SharePoint (SLQ Server Back end) and directories controlled by AD.

The one that cannot access the SQL Server errors: "Cannot Generate SSPI Context".  I have verified:
1) date and time
2) occurances of Security.DLL (win/system32; program file/common files/AOL...; Service Pack Files/i386 (x2))
3) Not using cached credentials

we recently moved our network and did not change any settings on any of the computers.  I read KB811889; those suggestions did not resolve the issue.

Please assist me in touble shooting this connection problem.  Also, how does changing the SQL Server Port on the server affect SharePoints connection to its database?

View Replies !   View Related
Cannot Generate SSPI Context For SQL2005...
Seen some similar topics here, but this is slightly different..
 
I'm running both SQL Server Enterprise and SQL Server 2005 locally on my computer (Windows NT).
I used Windows Authentication for both servers.
 
From one day to another I couldn't connect to the 2005. I got the classic "Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)" message. The enterprise server continued to work fine though.
 
I can still connect using "SQL Server Authentication", but now I don't have permissions to access the db or the system setting.. . I'm kinda stuck.
 
The strange part is that Enterprise works fine using "windows authenticaiton".
 
Do I really need to change Active Directory etc. Any other solutions?
 
Regards,
Johan
 
 
 
 
 
 
 
 
 

View Replies !   View Related
Database Won't Start In Cluster - Cannot Generate SSPI Context
Hi,
I have a MSSQL database running in a Microsoft cluster. I was working on troubleshooting for another SAP problem when they suggested I change the setting using hte SQL Server Client Network Utility to 'named pipes' from 'tcp/ip'. Every since, despite changing it back I'm unable to start the database in the cluster.

I'm kind of a newbie at this so I'd really appreciate any help in getting this database up and running.

Here is the error message from the event log:
sqsrvres] checkODBCConnectError: sqlstate = HY000; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

View Replies !   View Related
Urgent Help Needed !!! Cannot Generate SSPI Context Error
Dear Sir,

I tried installing sql server using mixed mode authentication but i am constantly receiving a error as follows and its getting shutting down


A connection could not be established to AICRR

Reason :Cannot generate SSPI context

Please verify sql server is running and check your sql server registeration properties(by right clicking on the AICRR node) and try again.


Please give me the resolution as soon as possible.

Regards

Arif

View Replies !   View Related
System.Data.SqlClient.SqlException: Cannot Generate SSPI Context.
Hi,

 

I am using .net 2 to connect to sql server 2005 - All works fine. When I move the sql server machine date forward (to test the application) the above message is returned.

 

Any ideas as to why this message is generated when I move the clock forward will be gratefully received.

 

Thanks

 

Pete Clements

View Replies !   View Related
Windows Authentication - Cannot Generate SSPI Context - Login Failed For User ''. The User Is Not Associated With A Trusted SQL
 
We are looking at developing an SQL Server 2005 Database and I would like to use Windows Authentication rather than SQL Server Authentication to connect our client app.
 
In our development environment, we have two Servers, one being used as a file server and the other as an SQL Server. We have now set up a domain using the file server as the domain controller. (We had previously been set up to use a workgroup).
 
I have set up an active directory group called SqlDevelopers and added an active directory user called Jonathan to it.
 
On the SQL Sever, in management studio, I have set up a new server login which uses windows authentication called DomainSqlDevelopers. I used the GUI to verify I could see the domain and the group.
 
The default database is set to a test database on the server. A user in the test database is mapped to the DomainSqlDevelopers and given the Roles dbo, db_datareader, db_datawriter.
 
To test the log in, on the server, I logged out as administrator and in as Jonathan. I could successfully access the server through management studio using windows authentication.
 
However, if I log in as Jonathan on my client PC and try to access the SQL Server using management studio and windows authentication, I have problems.
 
The first time I try I will get a timeout error. If I try again will get either:
 
Login failed for user ''. The user is not associated with a trusted SQL Server connection
 
Or
 
Cannot generate SSPI context
 
I can€™t determine any pattern to which of the above errors I get.
 
However, if I log in as administrator on my client PC, I can connect to the server using management studio and windows authentication.
 
Sounds like Active Directory/Domain or other Network issue (Not really my area). I would be grateful for any help.
 
Thanks,
 
Jon

 

View Replies !   View Related
Connection Error: &&"Cannot Generate SSPI Context&&"
hi,
While trying to connect to SQLSever 2000 or  SQLSever 2005 from a vb.net application ,
a user is getting the error "Cannot generate SSPI context" while other users
can still connect to the server.
and moreover, this user were able to connect before.
and if he restarts his computer, then try to connect after a lap of time, it will connect.
but if he waits and opens other applications,and then tries to open the application,it will not work.
 
so how to resolve this problem?
 
Regards,
 

View Replies !   View Related
SQL Server 2005 And SSPI Context On XP
Hello,
I have an XP box with SQL 2k working without any problems.  I am trying to install SQL 2005 CTP April on the same machine. Installation goes fine, but when I try to connect, I am getting an error "Can not Create SSPI Context".   Why am getting this error ?  DOes the machine needs to be on a domain to get connected? If yes, is there a work around? Can I use mixed mode? WhereHow do I specify  password for sa?

View Replies !   View Related
SSPI Context Error Message
Hai,
I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?

Narayanamoorthy

View Replies !   View Related
SSPI Context Error Message
Hai,
I'm having Windows XP SP2 version and I have installed SQL server 2005. Whenever I'm opening SQL server management studio in Windows Authentication Mode I get a pop message indicating that "SSPI context error message". What may be the problem and how to sort it out?

Narayanamoorthy

View Replies !   View Related
SSPI Context Error Message
Hai,

I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?

View Replies !   View Related
Cannont Create SSPI Context (SQL Connection Problem After 30 Minutes)
It makes no difference if I'm working with Enterprise Manager, QueryAnalyzer, Access, self written app with OleDb or Visual studio 2003builtin DB manager.Everything is fine but aufter some time - about 30 minutes I getmessage "cannot create SSPI context"After rebooting my machine I can work for another few minutes.Configuration:NB01 is my notebook with Windows XP ProSQL01 is another Windows XP Pro machine with SQL Server 2000 desktopDC01 is the domain controllerall machins within the same domain DOMAIN01The user is a domain admin and has every rightI'v seen some postings for this problem but not one useful idea how toresolve.As it runs perfectly for some time I don't thint it is a DNS problem orsomething like this.As there is no useful error message it must be some kind of bug.Has anybody resolved such a problem?

View Replies !   View Related
ODBC SQL Server Driver-Canot Generate SSPl Context
Dear all,

I am getting the message "Canot generate SSPI context",while i am working in a client system.I hope this is something related to networking.How to solve the problem.I can not connect to SQL Server once i got above mentioned message.

Please give your advice to understand and rectify the problem.

regards
Graceson

View Replies !   View Related
SSPI Context / [DBNETLIB][ConnectionRead (recv()).] General Network Error
Hello together,


since over a week I've been looking to
find out the reason for two error messages I get from our users and
servers, unfortunately without success up to now.



I really hope you can help me.



We are using Win 2k servers with active directory and SQL Server 2000,
clients are all Win XP with SP2. Versions of access are 2002 &
2003. The errors are userspecific and occur in both versions. The
SQL-Servers are accessed with an adp-file in 2002-format.



We have one usergroup which is member of specially many groups. This
affects the size of their windows access token which becomes constantly
larger. In order to enable those users to still access their mailboxes
on our Exchange servers, the DWORD entry "MaxTokenSize" with the
decimal value "65535" was made to the newly created key "Parameters" of
their registry branch
"HKLMSYSTEMCurrentControlSetControlLsaKerberos ".



Since then those users can not access any of our SQL Servers using the
windows authentification. One of them gets the error
"[DBNETLIB][ConnectionRead(recv().] General network error. Check your
network documentation.", the others the error "Check connection:
Failed: Cannot generate SSPI context".



In case of resetting the registry entries (by deleting them), the one
user receives the same error message as the rest while it doesn't make
any difference to those (but at least they can't connect to their
mailboxes).



After having researched the web, I realised in one of the SQL-Servers
logfiles the entry "Invalid buffer received from client.." which lead
me to start to believe it could have to do something with the kerberos
encryption in the first place. Therefore I asked if changes to the
tokensize had been made. I applied the change with "EXEC sp_configure
'network packet size', 65535 RECONFIGURE" on our testsystem and "EXEC
sp_configure" confirms that the value is run.



Consequence: The entry in the SQL Server log doesn't appear any longer, but the users still receive their error messages.





Do you have any hints?



Your comments will be highly appreciated!



Regards,

caracol

View Replies !   View Related
Cannot Generate SSPI Contect
I am getting error once in a while. It can be while either updating/inserting/selecting a record. I may have about 100000 hits give or take a few to the database.

The VB Application identified by the event source logged this Application MODE: Thread ID: 3300 ,Logged: ------------------------------------------------------------------------------------ Error Number :-2147467259 Error Description :Invalid connection string attribute Error Source :Microsoft OLE DB Provider for SQL Server ------------------------------------------------------------------------------------ System Error Number: 0 System Error Description: System Error Source: ------------------------------------------------------------------------------------ Context/Detail Error Description : :: updateOpsRecord :: ADO Error :: Error #-2147467259 Cannot generate SSPI context (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: HY000) (NativeError: 0) No Help file available

This is intresting to see. I tried looking up in all the forums and help file but no ansewers. Help would be appreciated.

Thanks,

Karan

View Replies !   View Related
UNABLE TO CONNECT TO SERVER
If you place an image of your server on a rebuilt server, rename it andchange the SID. You get an error message “UNABLE TO CONNECT” when youuse the SQL Query analyzer on a desktop computer to connect to theserver (hosting the image). If you add the server (hosting the image)to the Windows2000 server domain/active server and restart the server(hosting the image), you get the following error message: "YOUR SQLSERVER INSTALLATION IS EITHER CORRUPT OR HAS BEEN TAMPERED WITH (UNKNOWNPACKAGE ID). PLEASE RERUN SETUP."Wouldn't you think changing the name, the sid and adding it to a domainwould be enough to access it. I even created a new ODBC connection.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
Unable To Connect To Server
Hi,

I encounter (suddenly) the following error:

[ODBC SQL-Server Driver][Shared Memory] Unknown connection

by connecting either with the query analyzer or enterprise manager.
No connection possible anymore.

My configuration is:

Windows 2003 Server with
SQL Server 2000 SP3a Enterprise Edition with standard network configuration

One MSDE is still running on same machine and can connect.

I have checked with Compchecker, but no mismatches.

Any ideas ? It all sounds weired !

dajm

:(

View Replies !   View Related
Unable To Connect To MS SQL Server
Everything was ok, and running good... until...
---
I use a script, to pull data from DB, and display it... once I clicked URL, and got no response for few seconds, when it usually runs less than a second.
I waited a little, and pressed F5 to completely refresh the page. Success, liks worked, and connection went good... few more clicks, everything's working...
Left this script alone...
... 30 mins later ...
clicking the link - no response.
F5 - same staff, no response...
From that time 2 days passed, I'm still not able to connect...
...
This script was run under linux, using FreeTDS lib.
What is remarkable - SQL server runs on port 1051, instead of standard 1433, even though, there is no other programms listening to 1433.
...
Experimenting further...
...
Have ODBC DSNs installed on each computer, that run another programm, but connect to the same database.
All works just fine, even though I experience problems in Linux...
Until...
If I go to ODBC settings, and save them without changes - I'm not able to connect to that server from that moment...
ODBC set up to use TCP/IP connection... SQL server set up to use it too.
If I change it to Named Pipes - connection works. Switching back to TCP/IP - won't allow to connect again.
And there is no response from server. I tried to read dump of the data sent to the server - after sending login information - no response.

Anyone have any ideas??? :eek:

View Replies !   View Related
Unable To Connect To Server
HI :

After i re-install the SQL6.5, then i try to register the server, i got the following error:

Unable to connect to Server[Reason:[DB-Library] Invalid parameter in DB-LIBRARY function reference] register any way ?

So i just connect it, then nothing can really work anymore, because i can`t open any thing than get same error message every place i try to go !!!

Your kindness hint or advice to solve this problem is appreciated !!!

View Replies !   View Related
Unable To Connect To SQL Server
I am unable to connect to SQL Server using isql_w or enterprise manager. The ODBC settings register successfull and the services show as started. I have tried starting SQL server in single-user mode with minimum config to see if memory is a problem but still cannot connect. The error logs show SQL as having started successfully with no errors. Has anyone got any ideas?

View Replies !   View Related
Unable To Connect To Server
On a fresh installation of SQL Server 6.5, I have
opened the EM and registered the server but am unable
to connect. I get the error of 'A connection could not
be established to [ServerName]- [DB-Library] Unable
to connect: SQL Server is unavailable or does not exist.
General Network Error. Check your documentation.'

I've tried connecting with all different DB-Lib settings
to no avail. Ultimately, I want to use TCP/IP. I am,
however, able to connect to other SQL Server boxes from
this EM, just not the local server. I am able to stop
and start the services from Control Panel and from SQL
Service Manager.

Since I haven't been able to log into the local SQL Server,
I've registered the server in EM to log in with sa and a
blank password. I've already completely uninstalled SQL
and reinstalled it to see if that would help. It didn't.

Does anyone have any idea what the problem could be?

Thank you!
Toni

View Replies !   View Related
Unable To Connect To Server
From my Win98SE box with MDAC 2.6sp1, I can't connect to SQL (win2k, sql2k).
I've tried everything I know but nothing works.

I always get the following error:
Unable to connect to server 192.168.1.2
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC Sql Server Driver] Timeout Expired

some additional info...
- both computers are in a workgroup, not in a domain.
- this is a home network and they're connected via a Linksys cable modem router
- another box on this same lan can connect to sql just fine, although it's
running win2k.
- all boxes have identical DSN, Subnet...settings
- I also installed Jet4.0sp1 just in case, but that didn't help either
- I'm primarily trying to connect via TCP, although I have tried Named Pipes
as well
- i can ping both boxes from each other just fine
- odbc ping fails

MDAC has worked beautifully for me for the last several years. Did MS
change something recently...or is there another problem?

Thanks, Andre

View Replies !   View Related
Unable To Connect To Server
Hi,

I am running SQL 2000 on Windows 2000 Server. The clients are running different OS ranging from Win 98/NT/2000. Although i am able to connect to the local host, but whenever i try to connect over the network the following error pops up :

unable to connect to server <server name>
Server : Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]General network error. Check your network documentation.

I checked up the event long on the server and found the following entry:

Event Type: Warning
Event Source: MSSQL$NETSDK
Event Category: (8)
Event ID: 19011
Date: 1/20/2003
Time: 2:12:32 PM
User: N/A
Computer: <computer name>
Description:
The description for Event ID ( 19011 ) in Source ( MSSQL$NETSDK ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
(SpnRegister) : Error 1355.

May i further clarify that this error started today n till last week end (saturday, i am

stationed in India) there was no problem and the users were able to connect to the server

without any problem. My network engineer feels that its an sql problem and has nothing to do with network related issues.

i would appreciate if anybody could help me out. thanking in advance

- Paramesh

View Replies !   View Related
Unable To Connect To Sql Server
recently i made my PC dual boot by installing windows 2000 advanced server. It already had win2000 profesional installed on it. since then i have been unable to connect to sql server running on some other server(called CONTROLS) on the LAN. I am able to access the CONTROLS server thru 'my networkplaces' and able to see all its hsared directories and access htem. but when i open Enterprise manager i cannot connect to CONTROLS.
Please help me . i have already wasted 2 days over it.

View Replies !   View Related
Unable To Connect To SQL Server 7.0 With DMS
I have the problem with the SQL Client. I have one Document Management System setup using SQL SERVER 7.0 as the back-end. It's called DOCSOPEN from PC DOCS. When I run the ADDUSER.exe from a workstation(function in Docsopen), it should provide me the screen to add myself as a user. However, it provides me the error message telling that unable to connect. SQL SERVER is not available or does not exist. General network error. See your Documentation. I was so confused because I can ping that server, get into the SQL SERVER 7.0 remotely form the workstation, but I can't make the workstation see the SQL Server through the workstation. I checked both servers (document server and SQL Server). They are talking to each other. Therefore, I didn't know what is wrong with the SQL Client Configuration I set because I try to create a ODBC from the workstation and test that connection. It said that the test is successful.
Please help!!!!!!!!!!!!!!

View Replies !   View Related
SQL Server Unable To Connect... Please Help
I upgraded my 6.5 server to 7.0 two days ago running into small problems with the database upgrade wizard. I had some small problems with security which took me some time but was not that difficult once I figured it out. I then proceeded to switch back to 6.5 mode to transfer all the data that had been done that day to my development machine so I could then import it to the SQL 7.0 version. When I was done with the transfer I switched back successfully, started the server successfully, but I was unable to connect. I get the error "Connection could not be established...", so after several attempts to connect and shuting the server down I now am at a loss. The server runs fine in 6.5 mode but it will not connect in 7.0?? Tonight I am going to try to reinstall SP1, if that does not work I am going to try to reinstall SQL 7.0. Any suggestions???

View Replies !   View Related
Unable To Connect To Server
Hello. I am very new to SQL Server. I've tried to look through other posts on the forum but did not find the solution I needed. Please help.

I have SQL Server running on Machine1 which I am able to connect to. What I want to do is connect to this server through a Machine2 that is on my network.

Both Machines run on WindowXP Professional

On the server of Machine1, I have:
1. Under the security tab, I have created a New Login using SQL Server Authentication (general tab), checked all server roles (server roles tab) and checked to permit all databases (in the database access tab)
2. On the server, went to properties -> security tab and allowed for SQL Server and Windows authentication

On Machine2 when I try to register the server of Machine1 through the Register SQL Server Wizard, I am able to see the server. However, when I use the newly created Login Name and password (from step 1 of above). I get a Login Failed for user message. When I try to connect to the server through Query Analyzer I also get an unable to connect to server message (Server: Msg 18456, Level 16, State1)

What else do I need to configure to make it work?

Thank you!

View Replies !   View Related
SQL Server Is Unable To Connect
Hi there,

There is a SQL instance (sql2005) and  I am trying to add a new distribution. Replication wazard says:

SQL
Server is unable to connect to server 'SERVER1'. (New Publication
Wizard)SQL
Server is unable to connect to server 'SERVER1'. (New Publication
Wizard)

SQL Server replication
requires the actual server name to make a connection to the server.
Connections through a server alias, IP address, or any other alternate
name are not supported. Specify the actual server name, 'SERVER1'. (Replication.Utilities)

There is the only local instance of the server on local computer and  'SERVER1' is actual name.

What is wrong?
 
Thank yuu

View Replies !   View Related
Unable To Connect Server
hi,

i was unable to open the report manager...it is throwing an error saying that

Unable to connect to the remote server

but i am able to open the reportserver and capable to run the reports...

View Replies !   View Related
Unable To Connect To Server
 i have three computers with three differnent running systems.  about three days ago we were experiencing trouble getting into the game rooms at pogo.com.  we thought it would be trouble with java since it affected all three computers.  on the computer i am on now i have uninstalled and reinstalled java numerous times to no avail.  I am at my wits end trying to fix this. does anyone have any ideas.

View Replies !   View Related
Unable To Connect To SQL Server From ASP.NET Web App (Using Tutorial)
Hello everyone, I've been using the tutorial located here.I am using Microsoft Visual Studio 8.0.50727.42, Microsoft SQL Server 2005, and Microsoft .NET Framework 2.0.50727 SP1.The tutorial uses the SQL Express version and I cannot get it to connect to the standard SQL Server 2005 version.  I have used the website ConnectionStrings.com and the whitepaper located here and I wasn't able to get my web app talking to the database through many attempts.I am using a database in Microsoft SQL Server 2005 named SecurityTutorials.  This is located on my local machine.  There is a login named SecurityTutorials and a user in the SecurityTutorials database named SecurityTutorials who has default schema dbo, who owns the db_owner schema, and has role membership to db_datareader, db_datawriter, and db_ddladmin.  The password of this user does match the password in the connection string in web.config, I have verified this multiple times.The problem comes when I open up the CreatingUserAccounts page of this tutorial.  When I hit the button 'Create the User Account,' nothing happens.  And no record is inserted into the database.Here is my web.config file (if you need any other files then please let me know and I can post them but it is my understanding that this is the only file responsible for the database connection):<?xml version="1.0"?><!--     Note: As an alternative to hand editing this file you can use the     web admin tool to configure settings for your application. Use    the Website->Asp.Net Configuration option in Visual Studio.    A full list of settings and comments can be found in     machine.config.comments usually located in     WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration>    <appSettings/>    <connectionStrings>        <add name="SecurityTutorialsConnectionString"        connectionString="Server=localhost;Database=SecurityTutorials;User Id=SecurityTutorials;Password=**********;"        providerName="System.Data.SqlClient"/>    </connectionStrings>    <system.web>        <membership defaultProvider="SecurityTutorialsSqlMembershipProvider">            <providers>                <!--Add a customized SqlMembershipProvider -->                <add name="SecurityTutorialsSqlMembershipProvider"                type="System.Web.Security.SqlMembershipProvider"                connectionStringName="SecurityTutorialsConnectionString"                enablePasswordRetrieval="false"                enablePasswordReset="true"                requiresQuestionAndAnswer="true"                applicationName="SecurityTutorials"                requiresUniqueEmail="true"                passwordFormat="Hashed"                maxInvalidPasswordAttempts="5"                minRequiredPasswordLength="7"                minRequiredNonalphanumericCharacters="1"                passwordAttemptWindow="10"                passwordStrengthRegularExpression=""/>            </providers>        </membership>        <!--             Set compilation debug="true" to insert debugging             symbols into the compiled page. Because this             affects performance, set this value to true only             during development.        -->        <compilation debug="false" />        <!--            The <authentication> section enables configuration             of the security authentication mode used by             ASP.NET to identify an incoming user.         -->        <authentication mode="Forms">            <forms                                slidingExpiration="true"                                timeout="60"                            />        </authentication>        <machineKey                        decryption="AES"                        validation="SHA1"                        decryptionKey="1513F567EE75F7FB5AC0AC4D79E1D9F25430E3E2F1BCDD3370BCFC4EFC97A541"                        validationKey="32CBA563F26041EE5B5FE9581076C40618DCC1218F5F447634EDE8624508A129"                    />                <!--            The <customErrors> section enables configuration             of what to do if/when an unhandled error occurs             during the execution of a request. Specifically,             it enables developers to configure html error pages             to be displayed in place of a error stack trace.        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">            <error statusCode="403" redirect="NoAccess.htm" />            <error statusCode="404" redirect="FileNotFound.htm" />        </customErrors>        -->    </system.web></configuration>Note:  The password is an actually password.  Not sure if it'd be a good idea to post that here, even though it is a test database.Thank you all in advance for your advice! 

View Replies !   View Related
Unable To Connect To SQL Server Database.
Hi, I am working through "Sams Teach Yourself ASP Dot NET 2.0 in 24 Hours"
I am upto hour 20 where it says
Configuring an ASP.NET Website to Support Membership
To configure our website to support membership, we must launch the ASP.NET Website Administration Tool. To accomplish this, either click the ASP.NET
Configuration icon at the top of the Solution Explorer or click the Website menu's ASP.NET Configuration option. Either way will open a web browser pointed to a page through which the ASP.NET site can be configured. Figure 20.1 shows the ASP.NET Website Administration Tool.
To add user account support, click the Security link. This will take you to the Security screen shown in Figure 20.2. From this screen, you can specify the user accounts in your system, what roles for users exist, and the access rules for users.
However when I click security I get the following error message;
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store."
"The following message may help in diagnosing the problem: Unable to connect to SQL Server database."
If I test the provider I get this error;
"Provider Management""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, and then return to this tool to set the provider."
I am using MS VWD Express with MS SQL Express. I have run the 'aspnet_regsql' tool on my database which the book fails to mention and verified that the tables were created correctly. I have tried copying the MDF file directly into my 'app_data' directory but this made no difference. I have googled these errors and nothing seems to help. I can connect to the database through a 'SqlDataSource' and have had no trouble with the database in the previous sections of the book. I think it may have something to do with how I setup SQL Express or database permissions, I hope someone can help. Thanks in advance.
Here is a copy of my web.config; <?xml version="1.0"?><!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
--><configuration>
<connectionStrings>
<add name="MyFirstDatabaseConnectionString" connectionString="Data Source=.;AttachDbFilename=&quot;C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyFirstDatabase.mdf&quot;;Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />
</connectionStrings><appSettings/>
<system.web><!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.-->
<compilation debug="false" strict="false" explicit="true" /><pages>
<namespaces><clear />
<add namespace="System" /><add namespace="System.Collections" />
<add namespace="System.Collections.Specialized" /><add namespace="System.Configuration" />
<add namespace="System.Text" /><add namespace="System.Text.RegularExpressions" />
<add namespace="System.Web" /><add namespace="System.Web.Caching" />
<add namespace="System.Web.SessionState" /><add namespace="System.Web.Security" />
<add namespace="System.Web.Profile" /><add namespace="System.Web.UI" />
<add namespace="System.Web.UI.WebControls" /><add namespace="System.Web.UI.WebControls.WebParts" />
<add namespace="System.Web.UI.HtmlControls" /></namespaces>
</pages>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user. -->
<authentication mode="Windows" />
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>-->
</system.web></configuration>
 

View Replies !   View Related
Please Help Me About :Unable To Connect To SQL Server Database.
To All Members,When I create a new project and try to use the ASP.Net web application administration :security tab, I get the following :There
is a problem with your selected data store. This can be caused by an
invalid server name or credentials, or by insufficient permission. It
can also be caused by the role manager feature not being enabled. Click
the button below to be redirected to a page where you can choose a new
data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I am using Microsoft Visual Web Developer 2005 Express Edition with a local MS SQL Server 2000.I am new to all of this so a little help would be greatThanks.please mail me to dehackers@linuxmail.orgor                        izzuan@malysia.com 

View Replies !   View Related
SQL Server Unable To Connect On Vista
I have a problem that unble to connect the SQL Server2005 on Vista OS. After searching solution around but still not able to find the solution for me problem.
The Error was Error 26,
provider:SQL network interfaces, error:26 - error locating server/instance specified
 
Is any1 facing the problem on this? Any solution for this case?
 
TQ
 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved