I am unable to connect to express edition by specifying 'TCP/IP' in the Network Protocol option of 'Connection Properties' in managment studio. It gives the following error.
TITLE: Connect to Server
------------------------------
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I had already enabled TCP/IP from SQL Server Configuration Manager.
I'm trying to connect a DB in SQL express with a program in VB.NET Express. I'm using the Data Source Configuration Wizzard. When I select the file (.mdf), the following message appears:
Unable to open the physical file "path to my file". Operating system error 5: "5(error not found)".
An attempt to attach an auto-named database for file 'myFile' failed. A database with the same name exists, or secified file cannot be opened, or it is located in UNC share.
I'm using the Windows authentication for this, but if I try with the sa user, I get the following message:
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
Cannot someone please help me with following problem. I am trying to create a program to update a sql datbase from.NET 2003. I am doing this by using SQL Server Express 5. The problem is, is that when I run the program and click the button to view the table in SQL Express 5 I keep getting an 'System.NullReferenceException' and the table is not shown. When I look at the debug details it says that 'object reference not set to an instance of an object'. Am not sure where am goin wrong as the connection is opened to the local server in SQL Express and I have created a connection object and initialised it to the address fo the datatable in SQL. Please find below the code I am working on which shows the connection string in question and the table being called in button 6 which causes the exception. Any help would be greatly appreciated....thanks
using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient;namespace MovieBase { /// <summary> /// Summary description for Form1. /// </summary>public class Form1 : System.Windows.Forms.Form {private System.Windows.Forms.Button button1; private System.Windows.Forms.Button button2;private System.Windows.Forms.Button button3; private System.Windows.Forms.Label label1;private System.Windows.Forms.Button button4; private System.Windows.Forms.Button button5;private System.Data.SqlClient.SqlConnection sqlConnection1; private System.Windows.Forms.ComboBox GengreList;private System.Windows.Forms.Button button6; private System.Windows.Forms.Button button7;private System.Data.SqlClient.SqlCommand sqlSelectCommand1; private System.Data.SqlClient.SqlCommand sqlInsertCommand1;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; private System.Windows.Forms.Label label2;public DataSet MDSet = new DataSet(); SqlDataAdapter MyAdapt;private System.Data.SqlClient.SqlCommand sqlSelectCommand2; private System.Data.SqlClient.SqlCommand sqlInsertCommand2;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;public SqlConnection MovCon = new SqlConnection("Data Source = SHERMAN/SQLEXPRESS;Initial Catalog= MovieDBase;User Id=myUsername;Password=myPassword");
/// <summary> /// Required designer variable. /// </summary>private System.ComponentModel.Container components = null;public Form1() { // // Required for Windows Form Designer support // InitializeComponent();
// // TODO: Add any constructor code after InitializeComponent call // } /// <summary> /// Clean up any resources being used. /// </summary>protected override void Dispose( bool disposing ) {if( disposing ) {if (components != null) { components.Dispose(); } }base.Dispose( disposing ); }#region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary>private void InitializeComponent() {System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1)); this.button1 = new System.Windows.Forms.Button();this.button2 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button();this.label1 = new System.Windows.Forms.Label(); this.button4 = new System.Windows.Forms.Button();this.button5 = new System.Windows.Forms.Button(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();this.GengreList = new System.Windows.Forms.ComboBox(); this.button6 = new System.Windows.Forms.Button();this.button7 = new System.Windows.Forms.Button(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();this.label2 = new System.Windows.Forms.Label(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter();this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(184, 168); this.button1.Name = "button1";this.button1.Size = new System.Drawing.Size(96, 23); this.button1.TabIndex = 0;this.button1.Text = "Add A Movie"; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Location = new System.Drawing.Point(184, 248); this.button2.Name = "button2";this.button2.Size = new System.Drawing.Size(96, 23); this.button2.TabIndex = 1;this.button2.Text = "Delete A Movie"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button3 // this.button3.Location = new System.Drawing.Point(184, 208); this.button3.Name = "button3";this.button3.Size = new System.Drawing.Size(96, 23); this.button3.TabIndex = 2;this.button3.Text = "View Movies"; this.button3.Click += new System.EventHandler(this.button3_Click); // // label1 // this.label1.Font = new System.Drawing.Font("Myriad Web Pro", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.label1.Location = new System.Drawing.Point(280, 8);this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(120, 24);this.label1.TabIndex = 3; this.label1.Text = "MOVIEBASE"; // // button4 // this.button4.Location = new System.Drawing.Point(448, 344); this.button4.Name = "button4";this.button4.Size = new System.Drawing.Size(192, 23); this.button4.TabIndex = 4;this.button4.Text = "Current Movie Count"; this.button4.Click += new System.EventHandler(this.button4_Click); // // button5 // this.button5.Location = new System.Drawing.Point(496, 112); this.button5.Name = "button5";this.button5.Size = new System.Drawing.Size(128, 32); this.button5.TabIndex = 5;this.button5.Text = "Find Movie"; this.button5.Click += new System.EventHandler(this.button5_Click); // // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=SHERMAN;packet size=4096;integrated security=SSPI;data source="SHE" + "RMAN\SQLEXPRESS";persist security info=False;initial catalog=MovieDBase";this.sqlConnection1.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(this.sqlConnection1_InfoMessage); // // GengreList // this.GengreList.BackColor = System.Drawing.SystemColors.InactiveCaptionText;this.GengreList.Items.AddRange(new object[] { "Horror", "Comedy", "Family/Entertainment", "Drama", "Boxsets", "Sci -fi/Fantasy"});this.GengreList.Location = new System.Drawing.Point(184, 344); this.GengreList.Name = "GengreList";this.GengreList.Size = new System.Drawing.Size(121, 21); this.GengreList.TabIndex = 6; // // button6 // this.button6.Location = new System.Drawing.Point(264, 104); this.button6.Name = "button6";this.button6.Size = new System.Drawing.Size(160, 40); this.button6.TabIndex = 7;this.button6.Text = "View Movie List"; this.button6.Click += new System.EventHandler(this.button6_Click); // // button7 // this.button7.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.button7.Location = new System.Drawing.Point(360, 432);this.button7.Name = "button7"; this.button7.Size = new System.Drawing.Size(104, 40);this.button7.TabIndex = 8; this.button7.Text = "Exit Movie Base";this.button7.Click += new System.EventHandler(this.button7_Click); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" + "Table 1]";this.sqlSelectCommand1.Connection = this.sqlConnection1; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," + " Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" + "umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand1.Connection = this.sqlConnection1; this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director")); // // sqlDataAdapter1 // this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1; this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"), new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"), new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})}); this.sqlDataAdapter1.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDataAdapter1_RowUpdated); // // label2 // this.label2.Font = new System.Drawing.Font("Myriad Web Pro", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.label2.Location = new System.Drawing.Point(64, 344);this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(120, 23);this.label2.TabIndex = 9; this.label2.Text = "Genres"; // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" + "Table 1]";this.sqlSelectCommand2.Connection = this.sqlConnection1; // // sqlInsertCommand2 // this.sqlInsertCommand2.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," + " Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" + "umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand2.Connection = this.sqlConnection1; this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director")); // // sqlDataAdapter2 // this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2; this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"), new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"), new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})}); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.BackColor = System.Drawing.SystemColors.InactiveCaption;this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage"))); this.ClientSize = new System.Drawing.Size(704, 502);this.Controls.Add(this.label2); this.Controls.Add(this.button7);this.Controls.Add(this.button6); this.Controls.Add(this.GengreList);this.Controls.Add(this.button5); this.Controls.Add(this.button4);this.Controls.Add(this.label1); this.Controls.Add(this.button3);this.Controls.Add(this.button2); this.Controls.Add(this.button1);this.Name = "Form1"; this.Text = "Form1";this.ResumeLayout(false); } #endregion /// <summary> /// The main entry point for the application. /// </summary> [STAThread]static void Main() {Application.Run(new Form1());
Hello I am able to connect to the server and most of the time I can't connect. It is important to be able to connect so I can manage my mdf - database. To test ... I disable the firework but I still can't connect 90% of the time. Thank you in advance. ~ Peaches ~
just installed a new machine with windows 2003 server and SQL SERVER EXPRESS; I am able to connect to the SQL Server using my windows credentials however I am unable to log on to it using 'sa' (and no password) user; i get the following error message.
2007-05-07 15:42:12.32 Logon Error: 18456, Severity: 14, State: 7. 2007-05-07 15:42:12.32 Logon Login failed for user 'sa'. [CLIENT: <local machine>]
Hi, I am trying to connect with Database.mdf(Server Express) which is inside App_data with my ASP.NET website but i am receiveing an error which i have pasted below. Initially i tried using a business Object(.xsd) but while specifying the datasource in DataSourceobject i got nothing using wizard(which lists all the Adapter Methods(insert,select) of my business object) hence i am trying to connect without a business object. i.e just using the connection string(ConnectionStrings:DatabaseConnectionString) but this results below Error. Kindly help:; ------------------------------------------------------------------------------------------ Server Error in '/MapSpeaks1' Application. -------------------------------------------------------------------------------- Unable to open the physical file "c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 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: Unable to open the physical file "c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 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): Unable to open the physical file "c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735059 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 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) +359 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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
I installed Sqlexpress server 2005 and am able to connect to the server using the sqlexpress manager.
The connection parameters are:
server: 127.0.0.1 (This is an alias name pointing to TMD03SQLEXPRESS) username:sa password:test mode: sql server and windows authentication mode TCP/IP : enabled and listening on port number 1433.
But I am not able to connect to the server using PHP's mssql_connect function.
but none of them works. I also tried OSQL and SQLCMD and they don't work either. They give me the following error message.
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQL Native Client]Login timeout expired [SQL Native Client]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.
Can anyone please let me know what am doing wrong here?
I've never used SQL Server before. I installed VB 2005 Express (I've been working with VB since I was 16), and SQL Server 2005 Express.
I installed the server with all the default settings and created a small database to handle customer information (a remake of some Access and Oracle databases I've made before).
I'm told, however, each time I try to connect to the database via VB, that SQL Server isn't accepting remote connections...
Remote? It's on a local computer. So is VB...what is going on here? Is there a setting I've missed?
Within SQL Express 2005 running on Windows server 2003 using asp.net as the interface
This Is the Situation, at first i recieved this error "
Previously we received a €œfailed to generate a user instance of SQL due to a Failure in Starting the process for the user instance. The connection will be closed€?
I looked up this error and it seams to be a flaw/bug in sql server express the error occurs because of the use of remote login on the windows 2003 server.
The solution to this was to delete an sql server directory that resides here C:Documents and SettingsUSERNAMELocal SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS.
This indeed solved the failed to generate a user instance once the server was re-started however now I get a responce within the asp.net pages (which will have been built into those pages)
Your login attempt was not successful. Please try again.
now i have checked the simple errors caps lock etc and tried to log on to the SQL pages directly on the server with exactly the same result. the system was built by somone else and has not been modified "intentionally" just recently i added a few extra databases to the same server location, could this have caused the problem. to my knowlage (e.g i cant recall changing any settings)
there are one or two extenuation circumstances just recently the whole file directory was transfered from one HDD to another and then back to it's original position now i dont think this altered data but possibly there is some inbuilt security or something, i would most sincearly appreciate any questions or answers about this possibly things i havent mentioned that you need to know, just let me know i will get back to you
I have read all of the posts regarding this subject as well as 3"Dummies" guides and I keep having the same problems. I have a verysimple multi-user application that has to hit a database. Wecuerrently have this system deployed and it is working fine on adomain based network. We are scaling back and the network we will beusing is now a workgroup not a domain.It should be simple. I have XP boxes (clients) trying to hit the SQLServer Express database on a Windows Server 2003 machine. It is aclosed network so security is not an issue. I am trying to make thisthing wide open. All I want is for the user to be logged in on hisclient machine, run the application, and access/update the databasewithout having to re-authenticate to the SQL server. I want windowsto handle all of the authentication between the XP machines and theServer 2003 machine.Any suggestions would be greatly appreciated.
My situation: I have one virtual folder on a customer's server that hosts a web service which connects to Sql Server Express. This has been working for months.
The connection string that i use is: (obviously the names have been changed to protect the innocent) User ID=auser;Password=apassword;Initial Catalog=acatalog;Data Source=0.0.0.0SQLEXPRESS
I have recently added another virtual folder to the server, and it needs to connect to the same sql server. In this case it is a "regular" web site. I have it set up to use the same connection string as the web services site ( I can't think of any reason why it wouldn't be the same), however when I try to open the connection ( when I call mySqlConnection.Open(); ), I get get this error:
I am stumped as to why code in one virtual folder has no problem, while the other does. Both virtual and physical folders are on the same machine, and the Sql Server Express is installed on that machine.
I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).
I'm trying to connect from SQL Studio Express on Vista.
TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.
I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?
What could be the possible reason for this and how can i configure sql server 2005 express edition to make connections without specifying any portnumber in the connection string. Both the sqlserver database service and browser services are running.
I am trying to connect to sql server from a small c++ program , I am getting the following error
An error has occured when establishing connection to server. The failure may be caused by the fact that under the default settings does not allow remote connections.(Sql network interfaces error no 26 error locating server instance specified )
I chkd the default settings and it allowed remote connections. I also have default instance for the sql server
I am trying to connect to another computer in my local network which has Windows XP installed. It has SQL server 2000. I get an error message 'Time out period elapsed' when i try to connect to SQL server 2000 thru SQL Server Management Studio Express' Please guide.
Problem: I upgraded a SQL Server Express instance to SQL Server Enterprise, but I'm unable to connect to the SQL server from any remote machine. Only local connections work -- and I've verified that Remote Connections are allowed in the SQL Surface Confg. utility.
Scenario: Server1 has an SQL Enterprise edition installed as a default installation. SharePoint Server 2007 was installed later, and during that install a SQL Express edition instance was installed which is part of the standard SharePoint install. That Express instance contains all the SharePoint content databases.
So Server1 has SQL instances: Server1 <default install running Enterprise> Server1OFFICESERVER <previously running SQL Express, now upgraded to Enterprise>
After upgrading Server1OFFICESERVER to Enterprise, everything seemed to work fine (i.e. SharePoint works fine). However when I try to connect remotely to Server1OFFICESERVER I can't. I've verified through the SQL Surface configuration tool that remote connections are allowed. I've rebooted the server as well. I've tried connecting remotely using various PCs and various applications (e.g. SQL Server Mgmt Studio, Visual Studio, etc.).
I have a c# application running on my machine. I want to point to a sql server data base express edition running on other machine. By default, from server explorer Ionly acces data base files of the local machine. I dont have acces to remote servers.
I used the file explorer and opened the mdf file on remote server. I tried to acces the mdf file remotely but i got excepcion.
My questios are:
- Is sql server 2005 express edition supporting remote connection to mdf data base file?
- In other words, I can remotelty conncect to mdf file from remote machine ?
So, I how can point my application to remote sql server 2005 express edition data base running on other machine?
Hi, I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,
" Required Component Missing (Dialog box heading)
Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251 "
I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.
I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.
Thanks,
CLN
P.S. I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.
I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).
The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.
SQL Server Express 2005 is installed in mixed mode.
Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.
When I start Management Studio I get the following message and a suggestion to change a setting: (I can choose to continue and the system databases appear, but the DB I created does not.) "Unhandled exception has occurred in a component in your application. Cannot create a stable subkey under a volitile parent key."
************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. Any assistance is appreciated.
I had some issues on my server and had to uninstall .Net Framework 2.0, SQL Server 2005 Express, and SQL Express Toolkit. I installed SQL Server 2005 Express and it seemed to be ok.
Then my problems all started when I tried to install SQL Express Toolkit because I needed to install DTS Wizard again, and it errors out and wouldn't let me install it. So I uninstalled everything that's listed above again.
I then tried to install SQL Server 2005 Express again, and on the second from last screen, while its listing all the components and configuring them, I get the following error as it's configuring the last component... which was the SQL Server Database Services.
TITLE: Microsoft SQL Server 2005 Setup ----------------------------------------------------------- The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
I tried to re-install the SQL Server Express another 7 times wth no luck.
If anyone can point me in the right direction I'd really appreciate it.
Hello everybody I wrote a vb.net win app that uses a mssql 2005 express DB. On my localcomputer everything worked without a problem. Now I wish to deploy my app on a remote computer (that has mssql 2005 express installed), so. I added an app setup project to my project using the vs2005 setup tool, installed the app on the remote computer, and copied the mdf file to the remote computer. I'm able to see the DB through the remote computer mssql manager, But when I try to start the app on the remote computer I get this error massage : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. error: 0 - No process is on the other end of the pipe.) my connectionstring (in the config file) looks like that : <connectionStrings> <add name="Info_Manager.My.MySettings.MaxinetConnectionString" connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> <add name="Info_Manager.My.MySettings.MaxinetConnectionString1" connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> by the way changing the user instance attribute to "false" didn't help. Does anybody know how to fix this problem.
Every time i reboot my NT Server and the SQL server service starts up. It logs this message to the event Viewer
Severity: 9 Error:10004, OS: 11001 Unable to connect: SQL Server is unavailable or does not exist. General network error. Check your documentation.ConnectionOpen (gethostbyname()()).
I don`t have any problem with the databases, all the users are able to connect to server and database without any problems, looks like everything is working at its best. But i am little concerned about this error message.
Everything has been working fine our SQL Server (lets call it Server A) (v2000 under NT 4), however sometime over the weekend it is unable to connect to one of our other SQL Servers (Server B).
In the Event Viewer I found this error: SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip (TCP/IP)): Error 10013.
Everything on this server appears to be working fine, as in everything can connect to Sever A that needs to, but Server B can't connect to A, nor is it working the other way.
Also, Server A SQL Services run on port 2006, and B is on the standard 1433. Everything has been working with this up until today?
Let me start by saying that, yes we know v6.5 is no longer supported byMicrosoft and that moving to SQL2000 might resolve our problem.Actually the migration to SQL2000 is 1 to 2 months out and in the QAphase now. Unfortunately we need to resolve the current 6.5 issue nowas it heavily impacts a major revenue stream for the company with everyoutage we encounter.The Problem:At least once every 24 hours the SQL Server begins disallowing new userconnections. When this happens the 2 CPUs begin to thrash. About 5minutes later the error log begins to print out the following errormessage: "Unable to connect. The maximum number of '500' configured userconnections are already connected. System Administrator can configure toa higher value with sp_configure." No new connections can be made to theserver; however, the existing connections continue to function normally.We never see anywhere near 500 user connections in the system (it tendsto average around 350 connections). If we begin to disconnect users theserver continues reporting that the maximum number of users isconnected. Eventually running queries thru an open connection will hangand we have to resort to a hard reboot of the server as neither SQLServer will not shutdown nor will the operating system.The Server:Compaq Proliant DL380 with dual 863 MHz. processors (x86 Family 6 Model8 Stepping 3 GenuineIntel), 917,020 KB of physical memory, MicrosoftWindows 2000 Server (Version 5.0.2195 Service Pack 4 Build 2195), TotalVirtual Memory 3,138,688 KB, Page File Space 2,221,668 KBSQL Server:Microsoft SQL Server 6.50 - 6.50.479 (Intel X86). Some pertinentconfiguration settings: memory - 244100 (in 2K units), user connections– 500, RA worker threads – 3, max worker threads – 255We found one reference to the above error message in the MicrosoftKnowledge Base and that refers to a condition where the server has 2GBor more of physical memory with 1.5GB assigned to SQL Server. This doesnot pertain to our situation. Have any of you ever encountered thisproblem?I appreciate your insights.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
I am using MS VB 2005 Express to connect to a DB created in SQL 2005 Express and have not been able to make a connection. I am including answers to questions along with screen shots where it would make it clear, hope they come through. I f anyone has any ideas on what I have not done, or what I have incorrectly done, please let me know. I notice in the log that the database I am trying to connecto to does not show up as started. I don't understand why is doesn't show up, and I don't understand what I would need to do to start it.
[1] Client side:
What is the connection string in you app or DSN? (please specify) Data Source=.MSSQLSERVER;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMusuemInventory.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True
If client fails to connect, what is the client error messages? (please specify) SQL Network Interface, error 25, Connection string is not valid
Is the client remote or local to the SQL server machine? [Remote | Local] Local
Can you ping your server? [YES | NO ] In cmd.exe console, type €œping -a <server_name>€?. Yes can ping server
Can you telnet to your SQL Server? [YES | NO, please specify the error message In cmd.exe console, type €œtelnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+€™[€˜ to bring up telnet prompt and type €œquit€? <enter>. YES telnet connects on port 135
What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify). Using .NET Framework Data Provider for SQL Server
Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup) Yes
What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes]. Shared Memory
Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. No aliases
[2] Server side:
What is the MS SQL version? [ SQL Server 2005 | SQL Sever 2005 ]
Miscrsoft SQL Server Express Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)]. Express
What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm. Shared Memory
Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG? Yes
If SQL Server is a named instance, is the SQL browser enabled? [YES | NO] Yes Browser is running
What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account] Local System
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable] Not applicable
Do you make firewall exception for SQL Browser UDP port 1434? [YES | NO | not applicable ] No
[3] Platform:
What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ]. Microsoft Windows XP Professional Version 2002 Service Pack 2
Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify)]. McAfee
[4] Misc:
If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question. [5] Tips: 1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG Today entries in Log File
2006-10-01 03:07:35.14 spid51 Starting up database 'ReportServer'. 2006-10-01 03:07:35.28 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:07:35.28 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:07:40.50 spid51 Starting up database 'ReportServer'. 2006-10-01 03:07:40.62 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:07:40.62 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:08:45.62 spid51 Starting up database 'ReportServer'. 2006-10-01 03:08:45.75 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:08:45.75 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:10:50.75 spid51 Starting up database 'ReportServer'. 2006-10-01 03:10:50.85 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:10:50.85 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:14:55.85 spid51 Starting up database 'ReportServer'. 2006-10-01 03:14:55.98 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:14:55.98 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:23:00.98 spid51 Starting up database 'ReportServer'. 2006-10-01 03:23:01.17 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:23:01.17 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:39:01.20 Server Server resumed execution after being idle 47 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 03:39:01.20 spid51 Starting up database 'ReportServer'. 2006-10-01 03:39:01.31 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:39:01.31 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 04:11:01.31 Server Server resumed execution after being idle 1006 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 04:11:01.32 spid51 Starting up database 'ReportServer'. 2006-10-01 04:11:01.43 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 04:11:01.43 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 05:15:01.50 Server Server resumed execution after being idle 2926 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 05:15:01.50 spid51 Starting up database 'ReportServer'. 2006-10-01 05:15:01.59 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 05:15:01.59 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 07:23:01.76 spid51 Starting up database 'ReportServer'. 2006-10-01 07:23:01.87 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 07:23:01.87 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 08:18:02.20 Server Server resumed execution after being idle 1968 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 08:18:04.75 spid52 Using 'xpstar90.dll' version '2005.90.2047' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2006-10-01 08:20:02.13 spid52 Using 'xplog70.dll' version '2005.90.2047' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required. 2006-10-01 08:33:25.51 spid54 Starting up database 'aspnetdb'. 2006-10-01 08:33:26.00 spid54 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'. 2006-10-01 08:33:26.92 spid54 Starting up database 'MyCompany'. 2006-10-01 08:33:27.21 spid54 Starting up database 'ReportServer'. 2006-10-01 08:33:27.40 spid54 Starting up database 'ReportServerTempDB'. 2006-10-01 08:33:27.88 spid54 Starting up database 'aspnetdb'. 2006-10-01 10:50:18.71 Server Server resumed execution after being idle 4523 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 10:50:18.73 Logon Error: 17828, Severity: 20, State: 3. 2006-10-01 10:50:18.73 Logon The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>] 2006-10-01 11:19:40.78 Server Server resumed execution after being idle 672 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 11:36:52.20 spid52 Starting up database 'aspnetdb'. 2006-10-01 11:36:52.45 spid52 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'. 2006-10-01 11:36:52.98 spid52 Starting up database 'MyCompany'. 2006-10-01 11:36:53.29 spid52 Starting up database 'ReportServer'. 2006-10-01 11:36:53.56 spid52 Starting up database 'ReportServerTempDB'. 2006-10-01 11:36:53.96 spid52 Starting up database 'aspnetdb'. 2006-10-01 11:37:27.62 spid52 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'. 2006-10-01 11:37:28.21 spid52 Starting up database 'MyCompany'. 2006-10-01 11:37:28.48 spid52 Starting up database 'ReportServer'. 2006-10-01 11:37:28.71 spid52 Starting up database 'ReportServerTempDB'. 2006-10-01 11:39:02.56 spid52 Starting up database 'ReportServer'. 2006-10-01 11:39:02.67 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 11:39:02.67 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 12:39:22.70 Server Server resumed execution after being idle 2709 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 14:02:22.34 Server Server resumed execution after being idle 1287 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 14:02:22.34 Logon Error: 17828, Severity: 20, State: 3. 2006-10-01 14:02:22.34 Logon The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]
Last but not least: There is a wealth of information already available to help you answer your questions.
(1) SQL Server 2005 Books Online: http://msdn2.microsoft.com (2) Microsoft Support Knowledge Base: http://support.microsoft.com (3) SQL Protocol Team Blog: http://blogs.msdn.com/sql_protocols (4) MSN Search: http://search.msn.com/ or use your favorite search engine.
I am unable to connect SQL Server Management Studio to any of the databases on my computer. At this stage I am simply starting the Management Studio and asking it to connect to a database I made a few months ago before this connection trouble arose. I'm specifying the server name "BENCHLAP" which is the name of My Computer, using Windows Authentication. The error I get is: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The client is local. At least, it is if I understand correctly - the instance of SQL Server is installed on the same machine as the instance of IIS that I intend to use to test my web applications after we have resolved this issue, and the same machine as the one I shall use to view the application on. I can ping the server if i type "ping -a BENCHLAP". It is successful I think it also connects via telnet ok as well, by typing "telnet BENCHLAP 135" All client protocols are enabled, as are the server protocols. Don't know if this is a security risk but I did it to try and solve the problem, to no avail. There are no aliases, according to the Configuration Manager.
The server itself is SQL Server Express 2005, runnning on Windows XP Professional. My anti virus software is AVG. I'm afraid I don't know anything more, and have been researching this error for quite some time now. Is anybody able to help me please? Ben
Hi All, I am trying to connect to an SQL SERVER in a remote production server from ASP.net using following code. Dim conProd As New OleDbConnection("Provider=SQLOLEDB.1;Data Source=ServerName;UID=User Name;PWD=Password;Initial Catalog=Database")conProd.Open()I am getting following error while running this script [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. But I am able to connect to this server using following three other ways:1) Using query analyzer2) I created DSN and performed test connection, it succeded.3) In ASP.NET -> Server Explorer -> Data Connections, I added this connection and test connection also successful.I tried to connect to this server in VB 6.0 using following code Dim conProd As New ADODB.ConnectionconProd.Open "Provider=SQLOLEDB;Data Source=ServerName;Initial Catalog=Database; Timeout=500;", "UserName", "Password" I am able to connect using this above code in VB 6.0 also.But I dont what is happeing in .NET. Please help me. I am using XP and VS .NET 2003
I just installed MSDE but when I try to connect to a database or create a new database I get the following message:"Microsoft ASP.NET Web MatrixUnable to connect to the database.General network error. Check your network documentation.ConnectionRead (rec()).TDS buffer length too largeTDS buffer length too large"Can anyone tell me how to correct this problem?Thanks,
I have set up a database in SQL Server 2005 (The express version) and am trying unsucessfully to make a connection to it from MS Visual Web Developer 2005 Express version. I always get the same error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this error may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - could open a connection to SQL Server)" How can I set up SQL Server to allow remote connections? I am trying to establish a connection from my web page to this database. Is there a user that I need to establish on the SQL Server side?
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???
