Connection To SQL Server Files (*.mdf) Require SQL Server Express 2005 To Function Properly.
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)
2- UserLTSQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLTSQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
View Complete Forum Thread with Replies
Related Forum Messages:
Connection To SQL Server Files (*.mdf) Require SQL Server Express 2005 To Function Properly
hello, i've installed SQL server 2005 express and Visual web developper 2005 express. when i whant to create a database in VWD the following error occures: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=49251 i searched the internet but can't find the solution, i already reinstalled my complete workstation but the problem stays. please help!
View Replies !
VS2005 Error: Connection To SQL Server Files (*.mdf) Requires SQL Server Express 2005 To Function Properly.
Good Evening All, I've serached this forum and Google'd for a resolution to this issue, to no avail. Here's the scenario: I'm running VS 2005 on Windows Media Center laptop and need to create ASP.net membership for my web application built using VB. I have SQL Server Developer installed with instance name MSSQLSERVER. Previously, I uninstalled SQL Express and installed Developer edition and can now open and utilize Management Studio. Now, when I try to create a new SQL Server database in my solution's App_Data directory, I receive the above error. I already changed instance name in VS2005 per Tools-Options-Database Tools-Data Connections to MSSQLSERVER. Could someone provide me with a list of procedures to ensure proper setup of VS2005 with SQL Server Developer Edition? Thanks much for your help.
View Replies !
Error Creating Mdf - Connection To SQL Server Files (*.mdf) Require SQL Express 2005 To....
Connection to SQL server files (*.mdf) require SQL express 2005 to function properly. please verify the installation of the component or download from http://go.microsoft.com/fwlink/?linkid=49251 I AM GOING TO RIP MY HAIR OUT WITH THIS PROBLEM. I have reinstalled both sql server express 2005 and VWD about 5 times with the same problem. please, please, please someone throw me a bone here and help me resolve this problem. When I create a new EMPTY website and I rightclick on my website in the solution explorer and choose add item, I chooe SQL Database, I give it a name 'database.mdf' and click add. I get the following message: you are attempting to add a database to an asp.net application. for a database to be gfenerally consumable in your site, it should be placed inside the 'app_data' folder. would you like to place the database inside the 'app_data' folder? I click YES (I know this message is normal) then I get the following message: Connection to SQL server files (*.mdf) require SQL express 2005 to function properly. please verify the installation of the component or download from http://go.microsoft.com/fwlink/?linkid=49251 I can add anything else but this damn mdf file. thanks for all your help in advance.
View Replies !
I Created A Website On My Localhost With Three .mdf Files Using SQL Express But Now I Get An Error When I Try To Host It On My Web Server Without SQL Express. Need Some Help On How To Change My Connection
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error: here is my web.config file:<?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 xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings><add key="EmailFrom" value="webmaster@reaganpower.com"/> <add key="EmailSubject" value="File Ready for Download!"/><add key="SmtpServer" value=""/> <add key="MailUser" value=""/><add key="MailPassword" value=""/> <add key="MailPort" value="25"/><add key="EmailFormatSelected" value="Text"/> <add key="PageTitle" value="Send It Now!"/><add key="ShareLocalFolderPath" value="H:MIS DepartmentIntranetSendItNowFileStorage"/> <add key="httpDownloadPath" value="http://misfs/SendItNow/ContentFiles/"/> <!-- <add key="CurrentTheme" value="CleanBlue" />--> <add key="CurrentTheme" value="CleanOrange"/></appSettings> <connectionStrings> <add name="ConnectionString" connectionString="Data Source=(local)SqlExpress;AttachDbFilename=|DataDirectory|FileShareDB.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/> </connectionStrings><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.--> <identity impersonate="false"/> <roleManager enabled="true"/><compilation debug="true" strict="false" explicit="true"> <assemblies><add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation> <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="Forms"/> <!-- 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 !
How To Create Assembly Function Using Dll Files In SQL Server 2005???
Hiiiiiiii all I have to make a user defined function in c# as the class liberary and create a dll file, now i want to use this function in SQL Server 2005 as a part of CLR Integration I have tried like this CREATE ASSEMBLY abc FROM 'C:abc.dll' WITH PERMISSION_SET = SAFE but it gives me incorrect syntax error so plzzzzz anyone help me wht to do in my probbbbbbbbb??????? Pratik Kansara
View Replies !
Connection Strings, Trusted-connection VS Username-password, SQL Server 2005 Express
All -- Please help. I have some questions about connection strings. BACKGROUND... Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005. Note that I do not want to use the "Attach a database file" type of connection string. Note that I am using the site http://www.ConnectionStrings.com as a reference. Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination. QUESTIONS... (A) What exactly does the error in Item 4 mean? (B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string? (C) Are there any alternatives? (D) What do you suggest? Please advise. Thank you. -- Mark Kamoski
View Replies !
Required Microsoft Sql Server 2005 Express Server Roles For JDBC Connection
Hi! I have developed a database in MS SQL Server 2005 Express, to which I would require only bulkadmin server role from an external java application, because I only need to update rows, insert values or use select queries in the database. The problem is that, using either the Microsoft JDBC Driver 1.1 or the Java JDBC ODBC Driver and the Windows XP Data Base (ODBC) configurations, I need a user with sysadmin server role inside Sql Server, otherwise JDBC won't connect to the database using the selected user. Even if I leave the sql login with setupadmin or any server role lower than sysadmin, the connection is refused. Is there no way to connect using JDBC to MS Sql Server 2005 other than granting the connected user sysadmin rights? My code looks as follows: Code Snippet String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String url = "jdbc:sqlserver://FIREBLADE\SQLEXPRESS"; String user = "username"; String password = "password$$"; Connection conn; Class.forName(driver); conn = DriverManager.getConnection(url,user,password); if (conn != null) System.out.println("SQL Server Connection established ..."); I have heard that Java JDBC connections to Microsoft require high-level access. Any informed answer is more than welcome. Thanks for reading my post!
View Replies !
Connection Error To The SQL Server 2005 Express On Windows 2000 Server.
Hi, My application use SQL Native Client to connect to the SQL Server 2005 Express database instance. It uses IRowsetFastLoad for bulk insert and IRowset for other accessings. When this application runs at Windows 2000 Server, and there is another running instance of SQL Server 2000 for other service, my program fails to connect the the SS2005 express after running about 40 hours. The error message is 'Initialize datasource error(0x80004005)' The memory usage of SS2005 express is over 600 MB even though I limited the memory usage to 200MB using sp_configure stored procedure. Another programs also fail to running. For example, the ftp client return error message like this, 'No buffer space is supported.' and fails to connect to FTP server. Here is my code. Please check if there are any problems like threading models,MDAC version ect... ------------------------------------------------------------- HRESULT hr = CoInitialize(NULL); if ( S_OK != hr ) { return FALSE; } hr = CoCreateInstance(CLSID_SQLNCLI, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize, (void**)&m_pIDBInitialize); if ( S_OK != hr ) { return FALSE; } rgProperty[0].dwPropertyID = DBPROP_INIT_DATASOURCE; rgProperty[0].dwOptions = DBPROPOPTIONS_REQUIRED; // rgProperty[0].dwStatus = ; <-- not required in input or consumer rgProperty[0].colid = DB_NULLID; rgProperty[0].vValue.vt = VT_BSTR; rgProperty[0].vValue.bstrVal= bstrDataSource; rgProperty[1].dwPropertyID = DBPROP_INIT_CATALOG; rgProperty[1].dwOptions = DBPROPOPTIONS_OPTIONAL;//DBPROPOPTIONS_REQUIRED; // rgProperty[1].dwStatus = ; <-- not required in input or consumer rgProperty[1].colid = DB_NULLID; rgProperty[1].vValue.vt = VT_BSTR; rgProperty[1].vValue.bstrVal= bstrCatalog; rgProperty[2].dwPropertyID = DBPROP_AUTH_USERID; rgProperty[2].dwOptions = DBPROPOPTIONS_REQUIRED; // rgProperty[2].dwStatus = ; <-- not required in input or consumer rgProperty[2].colid = DB_NULLID; rgProperty[2].vValue.vt = VT_BSTR; rgProperty[2].vValue.bstrVal= bstrUserID; rgProperty[3].dwPropertyID = DBPROP_AUTH_PASSWORD; rgProperty[3].dwOptions = DBPROPOPTIONS_REQUIRED; // rgProperty[3].dwStatus = ; <-- not required in input or consumer rgProperty[3].colid = DB_NULLID; rgProperty[3].vValue.vt = VT_BSTR; rgProperty[3].vValue.bstrVal= bstrPassword; rgPropertySets[0].rgProperties = rgProperty; rgPropertySets[0].cProperties = cPropertySets; rgPropertySets[0].guidPropertySet = DBPROPSET_DBINIT; hr = m_pIDBProperties->SetProperties(1, rgPropertySets); if ( S_OK != hr ) { return FALSE; } hr = m_pIDBInitialize->Initialize(); if ( S_OK != hr ) { return FALSE; } // Create Session hr = m_pIDBInitialize->QueryInterface(IID_IDBCreateSession,(void**)&m_pIDBCreateSession); if ( S_OK != hr ) { return FALSE; } hr = m_pIDBCreateSession->CreateSession(NULL,IID_IOpenRowset,&m_pIUnkSession); if ( S_OK != hr ) { return FALSE; }
View Replies !
MDF Files With VS 2005 Installed SQL Server Express
I created a mdf file but couldnt for the life of me install it into SQL Sever Express [and when I say install i mean attach]. When I used SQL Server Ent, I had no issues. The only warning I got was that my mdf file was used by another process when I tried to attach with VS 2005 [ which is correct because ent had it]. I think mdf files are pretty touchy. Does anyone have any good articles on best practices? It seems you cant have a db with the same name as your attachment [ which would make sense] or have mdf files in the Data directory of your SQL Server instance you are trying to attach to. You will get the unc share error if you do. I think I need to start using user Instances but I could be wrong. You cant use them in ent but maybe i will solve my issue with attaching db files to express. I noticed that by default express doesnt install in mix auth mode and there might be some issues with access. How does everyone else normally install their mdf files for quick deployment [ say you want to deploy your db with your app so that users can quickly get started] ?
View Replies !
Attaching Sql Express Files In Sql Server 2005
Hello, I am using the full version of sql server 2005 management studio to attempt to attach sql express mdf files to sql server 2005. I was using the databases from an ASP.NET commerce starter kit in sql express. I want to update to sql server 2005, so i detached the dbs. i deleted the sql express management studio ctp and installed sql server 2005 from the free 6 month trial available online. I then attempted to attach the sql express files to sql server 2005 and get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server '<servername>'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'C:INETPUBWWWROOT<location>ASPNET.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476 I also tried with the original mdf files i had downloaded without making any changes. any help here? thank you, K
View Replies !
Considerations... Backing Up IIS 6 Web Files And SQL Server 2005 Express Database
Anyone know of a good "free" way to back up web files and SQL Server 2005 Express Database? I was able to use Windows Server 2003 Backup utility to back up the folder where the Databases were stored, as well as the web files, with no errors. But I have heard a lot of discussion that you can't just simply backup SQL Server data files? I'm wondering how sound the backup I've created is... Any suggestions?
View Replies !
SQL Server 2005 Express Connection
I am having trouble connecting to SQL Server 2005 Express using ASP.NET written in VB.NET (1.1 Framework) in VS2003. I am trying to programmatically connect to the SQL Server. Since this is a redistributable web application and I don't want to rewrite the connection string every time I distribute a copy, is there any way to automatically get a connection string without prompting the end user for one? I can get the server name and the data base name, but I don't know how to get a username. It returns an error saying SERVERASPNET can't log on. Can anyone help?
View Replies !
Nebie Connection Problems With SQL Server 2005 Express And VS 2005
I downloaded SQL Server 2005 Express and some sample databases (incl. Adventureworks_data.mdf), but when I try to Add Connection in VS 2005 to point to this db and use the Test Connection button, it gives the error: --------------------------- Microsoft Visual Studio --------------------------- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) --------------------------- I've tried setting the data source as either "Microsoft SQL Server Database File" or "Microsoft SQL Server", but get the same error. Any tips on verifying SQL Srv Express is installed correctly? Any ideas on how to solve this problem? Thanks in advance.
View Replies !
Having Connection Problems With SQL Server 2005 Express
This is a bit of a cross-post from the VS 2005 Forum, but we don't have a forum dedicated to SQL Server 2005...This is on my test machine running Windows XP Pro SP2 (NTFS),I have an existing SQL 2000 database located on a separate hard drive dedicated to data -- the e: drive.I just installed SQL Server 2005 Express, in the default installation directory (c:Program FilesMicrosoft SQL Server) and I cannot connect to that database on the e: drive. Named pipes, error: 40 (Remote access services are not installed by default).I don't want the database physically located on the c: drive.I've been looking all over for the solution for this, and can't find it.Advice or direction to reference materials would be appreciated.Tinker
View Replies !
SQL Server 2005 Express Connection Problem!!
Hello everybody I`ve installed Visual C# 2005 Express edition for evaluation reasons. After that I also installed Microsoft SQL Server 2005 Express edition also for evaluation. I then downloaed the installation scripts for the Northwind database and tried to install them. Unfortunately, every time I try to execute these scripts I get the error : C:SQL Server 2000 Sample Databases>osql -E -i instnwnd.sql [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. I`ve enabled named pipes in the configuration utility, but to no avail. This is also no firewall problem. It just can`t connect to SQL server. Anybody with similar problems or a possible remedy? George Papadopoulos
View Replies !
Sql Server 2005 Express And Network Connection
We have a native Visual C++ application compiled with VS 2005 that when it starts establishes a connection to a local (on the same computer) sql server 2005 express database through ADO with OLEDB provider for sql server, and keeps the connection opened during all its life. The computer could have any network connection for example a local network hence have a network adapter or an ADSL modem. When the application starts with the network connection active, any operation on the sql server connection fail after whether the network connection has been closed, for example disabling the network adapter or the ADSL modem. The first error I get is: description literally translate from italian "generic network error" in english may be "Communication Link Failure" SQL State: 08501 Native Error: 11 That doesn't happen whether the application start while the network connection is not active that is whether the sql server connection is established while the network connection is not active. That is whether network connection is not active I start my application and then enable and disable the network connection over and over and the application always works fine. I have noticed that when the sql server connection is opened while the netwok connection is closed the columns values of client_net_address and local_net_address in the sys.dm_exec_connections table are the localhost ip address 127.0.0.1 whereas if the sql server connection is opened while the netwok connection is opened that values are equal to the network adapter ones (ex 10.0.0.106). In the string connection we use "local" or "computer name" for server value. May be I have to use "localhost" instead of "local" in the sql connection string?
View Replies !
HELP!! SQL Server Express 2005 Engine Connection To My DB
Preface, I am just starting to learn about database and web development. I installed VS.net 2005 which updated my web site project file and automatically attached it to a database. It connected to ".app_dataaspnetdb.mdf". However it messed something up and the connection didn't work. If I create a project from scratch, it connects to its DB just fine, but not my upgraded project. However, when I publish my web site, I need to use ODBC. So, my thought was to simply set up the system locally in a way that will make it easy to connect on the web site. I was told to add a system DSN to the "Microsoft ODBC Administrator". I tried to add a "SQL Server" and give it the database name but it failed to connect. So, then I ran the SQL Server Configuration Manager and looked at the server properties and found this string under the advanced -> startup parameters.."-dc:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf;-ec:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG;-lc:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf" My database is in an entirely different folder. The database it looks like it is servicing is a "master.mdf" database installed under the SQL server install folder. So, I figured that I found my problem. I just have to change this file to map to mine. I replaced these three strings with paths to my aspnetdb.mdf/ldf files, and created a LOG folder. Howwever, it wasn't able to connect to this database. It said something like "it doesn't exist or you don't have permission", even though I gave it the right path. So, I'm at a loss for how to get my application to be able to use the ODBC interface to connect to its very own database on my local system. What do I need to do? Please help!
View Replies !
SQL Server 2005 Express Connection And MS Access
I just installed SQL Server Management studio express. I am trying to remotely connect to a SQL Server Express 2005 remotely. I was given the server name, user name and password, and used SQL Server authentication. It connected fine, and I was able to get at the intended database. I then went to ODBC data sources to add this SQL server using SQL authentication. I entered the server, user and password, and I got a nebulous "could not connect" error. I thought is may be because I still was connected in SQL Server Management studio express, so I closed it and tried again with the same error. I then reopened SQL Server Management studio express and tried to reconnect, and got the same nebulous error, and have not been able to connect since. I tried rebooting and reinstalling SQL Server Management studio express, but had the same result. Does anyone have any idea what I may have done and how to undo? Thanks, Steve Colino
View Replies !
Establishing Connection To SQL 2005 Server Express
Using localhost (127.0.0.1) an error occurred while establishing a connection to SQL Server 2005. Error message - An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (.Net SqlClient Data Provider) Error Number: 10061 Event Source: MSSQLServer Message text: Cannot connect to 127.0.0.1. Any ideas?
View Replies !
HELP Sql Server 2005 Express Connection Hangs Up
Hi I got an access 2002 application front end with a sql server 2005 express back end. Some of my clients are having some difficulties. After using the application for a while, some of the users are finding that the system just hangs up. It usually happens after the front end application has been running for about an hour (sometimes sooner and sometimes later). There are perhaps 1 to 5 concurrent users and I have checked to see if there are any firewalls stalling it (I think I check all of them)- Is there any way that SQL Server 2005 express could be caused to just stall- This even occurs with the odd laptop. All the appropriate protocols are enabled as well. These databses are not very large. ANY HELP WOULD BE GREATLY APPRETIATED!!! Thanks Frank Srebot
View Replies !
Cannot Establish A Connection In Sql Server 2005 Express
hi all here is the following error, what should i do. TITLE: Connect to Server ------------------------------ Cannot connect to KANGALERTSQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: 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 ------------------------------
View Replies !
SQL Server 2005 Express Connection Fail. Please Help Me
Hi all, When i attempted to connected to Microsoft SQL Server 2005 Express via ASP.NET 2.0 application, it seems to throw the following error. I had set up the Protocols for Express (TCP/IP and Named Pipes are both enabled) to allow remote connections using both TCP/IP and named pipes. Login failed for user ''. The user is not associated with a trusted SQL Server connection. 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: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL: 1. Add a "Debug=true" directive at the top of the file that generated the error. Example: <%@ Page Language="C#" Debug="true" %> or: 2) Add the following section to the configuration file of your application: <configuration> <system.web> <compilation debug="true"/> </system.web> </configuration> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode. Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. Stack Trace: [SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734883 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 ASP.sqlquerytool_aspx.Button_Click(Object s, EventArgs e) +49 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 I have been battling with error for 5 solid hours. Please help me thank you in advance
View Replies !
Connection Sql Server Express 2005 Over Internet ?
Is it possible to connect to a sql server express over internet or not ? - I am using a win2003 sp1 server. Freshly installed. - The server is directly connected to internet. - For the purpose of the test, I stopped the windows firewall and the IPSec service. - I stopped SQL server Browser service. - I find a free port (here : 1401) - I activated TCP/IP protocol in SQL Server Configuration Manager, and I have selected 1401 as the TCP port in the IPAll sextion of TCP/IP protection (and I remove the '0' of the dynamic TCP Port). - Restarted SQL server express... In the sql server log, I get the message "Serveur Server is listening on [ 'any' <ipv4> 1401]" But I never get an answer from the server. sqlcmd -S ip_of_the_server, 1401 -U username -P password is working fine if launched on the server. But I always get a timeout error from any PC. Same with a telnet on port 1401. Any idea ? -
View Replies !
Connection String To SQL Server 2005 Express Database
Hi, all. I am using VS.NET 2005 and SQL Server 2005 Express. I tried to use the following code to connect to a database named "AMSPROD" that I attached to SQL Server 2005 Express: dbConn = new OleDbConnection(Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAMSPROD_Data.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True); dbConn.Open(); I got an error asking for provider with the above connection string, then I changed the conncection string to be like follows: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAMSPROD_Data.MDF";Provider=SQLNCLI;Integrated Security=True;Connect Timeout=30;User Instance=True I got error: No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21) Then I changed the Provider to be like: Provider=SQLOLEDB, now I am getting the following error: Message: "Invalid authorization specification Invalid connection string attribute" Source: "Microsoft SQL Native Client" StackTrace: " at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at ISESAMSData.DbConnections.MakeConnection() in C:\ISES\ISESCommon\ISESAMSData\DbConnections.cs:line 74" TargetSite: {Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)} Strange thing is, when I use the Connect To Database under Tool menu of VS.NET 2005, I could make the connection to this database. Then I copied this connection string to the code, the connection couln't be made. I feel very confused. I am wondering if I need to add ASP.NET user to SQLExpress. But I don't know how to do it? Can anyone please help me out! Many thanks!
View Replies !
Sql Server 2005 Standard And Express Connection Questions
Hi all, i have standard edition of sql server, on a server hat doesnt have sql server standard would i be able to connect to it using my connection string. Or does the server has to have standard edition too. Is this same for express edition, and if possible to do this whats the difference between express connection string from standard edition thanks
View Replies !
Sql Server Express 2005 Remote Connection Problem
Dear all:I have a problem in the database connection for sql server express 2005. Actually I am a user of a free web-hosting plan offered by aspdotnet.sk, everything works well on my own machine, I put a local database file into the App_Data folder, and my connectionstring is:<add name=" ConnectionString1" connectionString=" Data Source=.SQLEXPRESS;Database=xuan;Integrated Security=True;AttachDbFilename=|DataDirectory|family.mdf;User Instance=True" providerName="System.Data.SqlClient"/>But when I uploaded all the files to the server and test it in the browser, it doesn't work any longer.The error message is:Could not open new database 'xuan'. CREATE DATABASE is aborted.Could not attach file 'I:DataWebaspdotnet.skxuanxuan_c3b7f052-101e-4eff-9ca5-3a91b7585e29wwwApp_Datafamily.mdf' as database 'xuan'.File activation failure. The physical file name "E:Visual Studio 2005WebSitesWebSite2App_Datafamily_log.ldf" may be incorrect.The log cannot be rebuilt when the primary file is read-only.I don't know why I keep getting this kind of message again and again...Please help...!
View Replies !
Oledbconnection In Vb.net 2005 And Sql Server Express Test Connection
Hey everyone, I was had just finished creating the architecture for a test databse using sql express 2005 and have been able to get the browser and sql service started just fine. However, When I try to create an oledbconnection or oledbadapter to the database using the Microsoft SQL Server engines I get the following error: I have tried using a direct path to the database in the server name and the computer's name itself. Everything is on the local machine and I have not started remotely connecting. [DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied. I am using windows authentication and have also specified the direct patht to the database in the attach database file: Thanks for the help. Shullaymahl
View Replies !
SQL Express 2005 Connection String Vs SQL Server (latest)
I'm a student at Boise State university and we're using SQL Express as part of one of our projects for ASP.NET programming. I liked it and I'm trying to use it to power a wiki that I'll be hosting from my home internet connection. The wiki is compatible with MSSQL server, but it won't connect to SQL Express. I suspect that the problem is in the connection string, mainly because the apps we're developing for class use a connection string like: <add name="AspNetForumConnectionString" connectionString="Data Source=localhostsqlexpress;Initial Catalog=gaming.forum.nxnw;User ID=*********;Password=*********;" providerName="System.Data.SqlClient"/> and note the Data Source. The wiki I'm using is PHP based and uses ADObd to connect databases and has a driver for MSSQL, but not SQL Express (no surprise, really). I know just enough php to be dangerous to code and I've tried modifying the adodb-mssql.inc.php, but I can't seem to make the right change. So, all that said, my question is: Is there a way to change what SQL Express 2005 will accept as a connection string? I've been looking, but I'm not even sure what the setting would be called. Thanks, Les
View Replies !
Problem With Access 2003 And Sql Server 2005 Express Connection
I have an Access 2003 project (sp2) and the data in SQL Server 2005 Express. My problem is when I try to make querys, diagrams, etc in Access, a warning tell me that I have installed a version of Access that is older than the version of SQL and all the designs that I make not be saved, and recommend a service pack for Access 2003 to correct the problem. Can anybody help me, where is this SP??
View Replies !
SQL Server 2005 Express Remote Connection Problem Via SSMSE
Hi, I am having problem with remote connection via TCP/IP connection on default port 1433. TCP/IP connection are enabled on the server. any possible solution ? See problem below: TITLE: Connect to Server ------------------------------ Cannot connect to ns1.iandigroupltd.com,1433. ------------------------------ ADDITIONAL INFORMATION: 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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------
View Replies !
How To Shutdown SQL 2005 Express Properly
While working on my Visual C# 2005 Express programs, I will sometimes open SQL 2005 Express to look at the database. Then I will disconnect the database and exit the SQL Server Management Studio Express. Then when I run my Visual C# 2005 program the next time, I will always get this error message. "Cannot open user default database. Login failed...." Here is a copy of my connection string string cs = "Data Source=.\SQLEXPRESS;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\hdcTemperatureCableReadings.mdf; Integrated Security=True;Connect Timeout=30;User Instance=True"; string strSelect = "Select * from CableReading"; SqlConnection tcrConn = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("Select * from CableReading", tcrConn); tcrConn.Open(); The error is being generated when "tcrConn.Open()" is being executed. This is line 27 of my program. My question is: Am I shutting SQL 2005 Express down wrong when I go in and look at the database. The SQL 2005 Express is located on the same computer that I am writing my program on. I copied the error message to the clipboard and copied into this thread. System.Data.SqlClient.SqlException was unhandled Message="Cannot open user default database. Login failed. Login failed for user 'HDC\jfeeney'." Source=".Net SqlClient Data Provider" ErrorCode=-2146232060 Class=11 LineNumber=65536 Number=4064 Procedure="" Server="\\.\pipe\8A52A6B8-493D-45\tsql\query" State=1 StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at WindowsFormsApplication1.Form1.button1_Click(Object sender, EventArgs e) in C: empTestCableReadingTestCableReadingForm1.cs:line 27 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at WindowsFormsApplication1.Program.Main() in C: empTestCableReadingTestCableReadingProgram.cs:line 18 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() InnerException:
View Replies !
Can Multiple Workstations Running SQL 2005 Server Express Attach To The Same Database Files On A Shared Network Location?
Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?
View Replies !
Linked Server To Text Files: Is Possible To Detect Changes Made To Those Files? (SQL Server 2005)
Hi gurus, I've created a linked server (and set up the corresponding schema.ini file) in order to perform bulk-inserts from some CSV text files into SQL tables (from my standpoint the text files are just for reading purposes). The linked server works fine (I can select the data in the files without a problem). Now the question: is possible to automatically detect when one or more of those files change in order to start the import process automatically? Something like having a trigger created on the CSV files Or there's no easy way to do that so I have, to say something, to create a Job that periodically checks if the files have changed programatically (say, recording each file's timestamp everytime is imported and comparing the recorded value with the current one, or whatever)? Thanks a lot in advance!
View Replies !
How Can I Re-install The Northwind Database In SQL Server Management Studio Express?Use SqlDataSet && The .Fill Method Properly?
Hi all, In my VB 2005 Express, I created a Windowds Form application "shcDataSet" that used 1 SqlConnection, 1 SqlDataSet and 3 SqlDataAdapters associated with the Northwind Database in my SQL Server Management Studio Express. The SqlConnection had "User Instance" in the following ConnectionString: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataorthwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True. The 3 SqlDataAdapters were for the Northwind files "Customers", "Orders" and "Order Details" used in the SQLDataSet "AllOrders" with a AllOrders.xsd file. I ran the "shcDataSet" applicatyion and it worked fine. After the execution of "shcDataSet", I checked the Northwind database in my SQL Server Management Studio Express and clicked on "+" in front of Northwind database-I did not see any file showed up and I got the following error message: Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional information: one or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. (Microsoft SQL Server, Error:5173). If I executed the "shcDataSet" application again, I got a new error: SqlException was unhandled - Cannot open user default database. Login failed. Login failed for user 'myPC##myName' ------->daCustomers.Fill(AllOrders11, "Customers"). I have 3 questions to ask: (1) How can I re-install the Northwind database in SQL Server Management Studio Express? (2) When I use the .Fill Method, do I have to tell the SQL Server Management Studio Express to load and/or unload the Northwind files "Customers", "Orders" and "Order Details"? (3) After I executed the "shcDataSet", should I Upload the 3 Northwind files back to the SQL Server Management Studio Express? Please help and advise. Thanks, Scott Chang
View Replies !
CONNECTION STRING TO A REMOTE SERVER WITH SQL EXPRESS 2005, FIXED IP ADDRESS
I'M HAVING AN ISSUE, UNDERSTANDING, THE CONNECTION STRING. I WANT TO CONNECT TO AN INSTANCE OF SQLEXPRESS ON A REMOTE SERVER WITH A FIXED IP ADDRESS THE TCP PORT IS OPEN TO 1433 I OPENED THE PORT ON THE ROUTER AND THE WINDOWS 2003 FIREWALL MY CODE IS AS FOLLOWS: S = "Provider=SQLNCLI;" S = S & "DATA SOURCE=44.66.777.888,1433SQLEXPRESS;" S = S & "INITIAL CATALOG=TESTDB;" S = S & "Persist Security Info=false;" S = S & "UID=TEST999;" S = S & "Pwd="TEST999888;" CnMgt.ConnectionString = S CnMgt.Open S I'VE FOLLOWED THE STEPS OUTLINED IN ARTICLE 914277 CAN SOMEONE HELP? THANK YOU PS. IF THE CLIENT IS LOCAL, I HAVE NO ISSUE OPENING THE DATABASE. I DO NEED TO OPEN THE DB FROM FROM CLIENTS.
View Replies !
How To Apply SQL Server 2005 Express SP1 To The Version Of SQL Server 2005 Express Which Installs With Visual Studio 2005?
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media. How can apply SQL Server 2005 Express SP1 to update this existing instance? Currently, if I run this query: SELECT @@version I get the following: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) After applying SP1, I should get 9.00.2047.00. Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1: http://msdn.microsoft.com/vstudio/express/sql/download/ Thank you, Bashman
View Replies !
SQL Server 2005 Order By Date Does Not Sort Properly
I am using Access 2003 as a front-end to a SQL Server 2005 database.I make design changes using SQL Server Management Studio. I have atable that includes a datetime column. I create a view and sort bythe datetime field. When I initially look at the result it is sortedcorrectly. Then I save the view and re-open it and it is not sorted.I've simplified the view so it only contains the date field and itstill does not sort. Here is the view:SELECT TOP (100) PERCENT Period_DateFROM dbo.Period_SummaryORDER BY Period_Date DESCThe date seems to be a random order.I don't have this problem in the SQL Server 2000 version of thedatabase.Help please!Thanks,Jerry
View Replies !
ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer
Hi All, I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine. I would now like to install my application on another workstation and connect remotely to the database located on my development machine. The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver? Thanks!
View Replies !
Can I Use &&".dbp&&" Files With Visual Studio 2005 + SQL Express Server?
Alright I'm using Visual Studio 2005 with SP1 and SQL Server Express 2005. I've downloaded all the updates on Windows Update. I'm joining a project late and trying to get the C#/SQL web-app up and running. My project manager has it built with Visual Studio 2005 pro and a full blown corporate license for the SQL server, but I don't have access to the SQL server quite yet. When I try to open the "LLRCWEB.sln" file I receive the following error: "The application for project 'C:Documents and Settings......LLRCSQL.dbp' is not installed. Make sure the application for the project type (.dbp) is installed." Has anyone encountered this problem before? Are there any plug-ins or particular application versions you know are required to handle '.dbp' files, or will I have to Install Visual Studio 2005 Pro and get access to the SQL server? Any input would be greatly appreciated
View Replies !
|
TRACKER
