Hi all,
I was looking for SQL server agent object in sql express to create a new job in order to process my abandoned shopping carts in my online shopping project. If neone knows how to get this done..i wud be grateful...thanks!regards,
mandeep
I created an app in vs2005 and everything works perfectly in the development environment. I've published the site to my local IIS, but when I try to log in, it doesn't allow me. I'm assuming that it has something to do with the db not working correctly. Unfortunately I don't know how to debug to see where the problem is coming from now that it's running on my 'live' IIS. Does anyone have any ideas on what could be the problem. I have some settings in the web.config, which have been working perfectly.
<appSettings><add key="UserName" value=""/><add key="Password" value=""/><add key="Server" value="xxxxxxsqlexpress"/><add key="Database" value="xxxxx_xxx_users"/><add key="UseTrusted" value="True"/></appSettings>
I had a local guy at the office here saying that the ASP.NET user needs to be granted access to sqlexpress2005, but I wasn't sure on how to do that.
So all in all, My app works in Visual Studio 2005, and not in IIS. There are no errors when loading various pages. They all load correctly and without error. It seems that it's just when I try to do anything with the DB.
Thanks for the help. I appreciate it!
I need to create a job and schedule it in sql server 2005.But the sql server agent option doesnt come under the database instance in the object explorer.Do I have to instal some other component of sql server 2005?
View 1 Replies View RelatedI have read many threads on this issue & tried multiple solutions to no avail.
Here's my environment: SQL 2000, Logged directly into server via VPN (so it should be like I am physically at the server).
I've set up a DTS Package that executes an Access procedure. The package runs fine when I execute manually. When I execute via schedule, it fails on the error "ActiveX component can't create object: 'Access.Application'. The actual statement is:
Set objDB = CreateObject("Access.Application")
I know that Scheduled jobs default back to the SQL Agent permissions. I have reset SQL Agent to use my Windows NT account login so it should have the exact same permissions, etc. that I have when I execute manually?
Any help will be GREATLY appreciated!!!
Thanks mucho,
Brian
Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.
View 1 Replies View RelatedHi all,
The following dbo.Tables of Northwind.mdf in my .SQLEXPRESS (SQL Server Management Studio Express) are missing:
dbo.Categories
dbo.CustomerCustomerDemo
dbo.CustomerDemographics
dbo.Customers
dbo.Employees
dbo.EmployeeTerritories
dbo.Order Details
dbo.Orders
dbo.Products
dbo.Regions
dbo.Shippers
dbo.Suppliers
dbo.Territories.
But, I have these dbo.Tables in a different Database "xyzDatabase". How can I copy each of these dbo.Tables to the another blank dbo.Table of Northwind Database?
I right clicked on the dbo.Categories and I saw the following thing:
dbo.Categories
New Table...
Modify
Open Table
Script Table as |> CREATYE To |>
DROP To |>
SELECT To |>
INSERT To |> New Query Editor Window
File....
Clipboard
UPDATE To |>
DELETE to |>
From the above observation,I think it is possible to copy the dbo.Table from the one Database to the Northwind Database that needs to be repaired. Please help and advise me how to do this task or tell me where I can find the Microsoft document that gives the details of this X-copy thing.
Thanks in advance,
Scott Chang
P. S. I am using VB 2005 Express to create a project to learn "Calling Stored Procedures with ADO.NET" (see Paul Kimmel's article in http://www.developer.com/db/article.php/3438221) that needs the dbo.Tables of Northwind Database and my Northwind Database has been screwed up for quite a while and needs a big repair.
Does any one has any clue for this error ? I did went through a lot of articles on this error but none helped . I am working in Visual studie 2005 and trying to upload image in sql database through a simple form. Here is the code
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.IO;
public partial class Binary_frmUpload : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{
}protected void btnUpload_Click(object sender, EventArgs e)
{if (FileUpload.HasFile == false)
{
// No file uploaded!lblUploadDetails.Text = "Please first select a file to upload...";
}
else
{string str1 = FileUpload.PostedFile.FileName;
string str2 = FileUpload.PostedFile.ContentType; string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
//Initialize SQL Server Connection SqlConnection con = new SqlConnection(connectionString);
//Set insert query string qry = "insert into Officers (Picture,PictureType ,PicttureTitle) values(@ImageData, @PictureType, @PictureTitle)";
//Initialize SqlCommand object for insert. SqlCommand cmd = new SqlCommand(qry, con);
//We are passing Original Image Path and Image byte data as sql parameters. cmd.Parameters.Add(new SqlParameter("@PictureTitle", str1));
cmd.Parameters.Add(new SqlParameter("@PictureType", str2));Stream imgStream = FileUpload.PostedFile.InputStream;
int imgLen = FileUpload.PostedFile.ContentLength;byte[] ImageBytes = new byte[imgLen]; cmd.Parameters.Add(new SqlParameter("@ImageData", ImageBytes));
//Open connection and execute insert query.
con.Open();
cmd.ExecuteNonQuery();
con.Close(); //Close form and return to list or images.
}
}
}
Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.Source Error:
Line 32:
Line 33: string str2 = FileUpload.PostedFile.ContentType;
Line 34: string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
Line 35:
Line 36: //Initialize SQL Server Connection Source File: c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs Line: 34
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
Binary_frmUpload.btnUpload_Click(Object sender, EventArgs e) in c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs:34
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
When I try and run Report Builder Reports i get this error message "Object reference not set to an instance of an object. "
I can run reports locally but not from Report manager
here is the stack trace info
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
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:
[NullReferenceException: Object reference not set to an instance of an object.]
Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces) +18
Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e) +358
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +482
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
when I run a package from a command window using dtexec, the job immediately says success.
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 3:37:41 PM
Finished: 3:37:43 PM
Elapsed: 2.719 seconds
However the Job is still in th agent and the status is executing. The implications of this are not good. Is this how the sql server agent job task is supposed to work by design.
Thanks,
Larry
Hi all,
I'm getting this problem 'Object reference not set to an instance of an object.' whenever I try to review a report and I checked the log file and this is what it had
w3wp!ui!1!11/14/2006-10:54:20:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Some previous forums stated checking the webconfig file but the web config file look okay. Is there another way to fix this.
Much Thanks,
Carl
I can't start SQLEXPRESS.
The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".
Any thoughts why this might be and how I can fix this?
hiya,
I have sqlExpress and sqlServerManagementStudio on my XP pro box.
Will the installation of sqlExpress (Advanced Services) cause any problems?IS thereanything that I shold be aware of in advance?
many thanks,
yogi
Hi All,
I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.
If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.
But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.
Can anybody help me out .
Regards,
Doppalapudi.
We just moved source server to newer, bigger box ... Windows 2003 and Active Directory ... Snapshot agent worked but distribution failed ... Same login as on older machine, login is sysadm, used DCOMCNFG to allow ability to launch process ... What are we missing?
View 4 Replies View RelatedBecause of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.
I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?
I've had VS2005 installed for quite some time but I just purchansed SQL Server 2005 Developer and installed it. How do I accomplish integeration with SQL Server 2005 to VS2005? I had C# express at one point and SQL Express with the full tool install. That provided me with a designer for SQL Server (which was simply VS2005) and a seperate development environment under C# express. How do I integerate them so all the functionality resides within VS2005?
Any help you can provide will be much appreciated.
Thanks,
Dane R. Vinson
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.
hi,
i've currently created a linked server using sql server management studio express (it connects to an oracle database to draw data), i can query it all fine using the query analyzer with sql server etc.
how can i start using the linked server data with visual studio 2005? i can't seem to find the linked server anywhere inside the server explorer, am i suppose to import it / connect to it any specific way so i can start using the data retreived from the linked server?
thanks in advance!
HiI recently installed MS SQL Server 2005 Developer Ed. w/ SP2 on my XP... I use VS2005 to create personal websites. I was previously using SQL Server Express, and things worked fine by default settings. I am a beginner to web development and I really don't know anything about SQL Server. I'm guessing it needs to be configured somehow to work with VS, but I have no idea how to do that. I have an existing Web App which uses a database for login functionality, and everytime I try and log on I get this message:An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified)I made sure that the Server's database engine accepts remote connections but that didn't help. Does anyone have any suggestions?~Miro
When I try to attach an ".mdf" to a project by right clicking on the project name the software looks for an instance of SQL Server 2005 Express. How do I alter this behavior to have it look to my full copy of SQL Server 2005 which appears to be working correctly?
View 1 Replies View Relatedhi
I build a SQL Server Report using VS2005 in SQL Server 2005, Application is building with out any errors..I am able to preview the report data also
If I deply the application on http://localhost/ReportService I am getting the A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer) error.
please help me, what is the problem?
thanks
Rukku
Hello All,
I had VS2005 in my machine and was working with a mobile device using Sql Server CE. While compiling and deploying device application to my mobile device it used to deploy the Sql Server CE cab files also.
But now i have migrated to another machine ( Vista OS ) and installed VS2005 newly etc., Now when i try out the deployment of device application to my mobile device it is not deploying the Sql Server CE cab files but just copies the SqlServerCe dll file.
So when my application launches in the mobile device i get an error can't PInvoke sqlceme30.dll etc.,
I know that i can manually copy the cab files to my device and work. Its little tedious. Can anyone tell me how to achieve the behavior of my old VS2005 wherein it automatically deploys the SqlServer CE cab files? Is there a setting in VS2005 to enable this. I read in one of the posts that we can go modify the option Tools->Options->Smart device and enable an option to deploy the latest updates etc., But i couldn't find such an option in my VS2005.
P.S: I have installed my SqlServer Mobile edition 3.0 SDK to the default path under program files. Should i install it under VS2005 smartdevices SDK or something like that? I tried that also but still no success.
I have a default SQL server 2005 setup on my machine.
There is a large database to whom i can connect.
I made my own data by Sql server Mobile on my local machine and then try to connect it
to the the application in visual studio 2005.
But it each time it gives that the port cannot be open.
I am a native client for SQL server.
Do we have any idea how wil i connect to database local to machine with the
application in Visual studio 2005 with C# language.
thanks
Prashant Gupta
The actual message i am getting
Microsoft SQL Native Client Version 09.00.2047
Running connectivity tests...
Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][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.
TESTS FAILED!
Dear Community,
Microsoft SQL Server 2005 Everywhere Edition Tools for Visual Studio 2005 Service Pack 1 Beta is available for download at the following location:
http://www.microsoft.com/downloads/details.aspx?FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en
Microsoft SQL Server 2005 Everywhere Edition Tools for Visual Studio 2005 Service Pack 1 Beta is installed after the installation of Visual Studio 2005 SP1 Beta and updates the Smart Device Development components in Visual Studio 2005 SP1 Beta with the SQL Server 2005 Everywhere Edition design time UI/Dialogs, device CAB files, and includes new features like |DataDirectory| and ClickOnce support for ease of deployment
We would highly appreciate your feedback about the Beta release.
Regards
Ambrish Mishra
Program Manager
SQL Server Everywhere Edition
Dear Community,
I am happy to announce the availability of the beta of Visual Studio 2005 Service Pack 1.
Based on your feedback, Visual Studio 2005 Service Pack 1 addresses issues that were found through a combination of customer reports, MSDN Product Feedback Center and internal testing. You can download the beta by registering on the Microsoft Connect Site: (http://connect.microsoft.com/visualstudio).
We look forward to your feedback on the Beta release. More information on the final version of SP1 will be available soon.
Thanks,
Anand
Program Manager
Visual Studio for Devices
Hello,I am using SQLServer Express and Visual Studio 2005 to create the website. I would like to implement FullText search, but have never done it before. I have looked at the msdn documentation on FullText search in SQLServer 2005 here http://msdn2.microsoft.com/en-us/library/ms142519.aspx.I cannot seem to figure out how to use a FT search using Visual Studio. Can someone please help me configure my database and then explain how I can run queries based on user input to return data?
View 5 Replies View Related
This post is an extension onto the one below....
Please read my question at the bottom... cheers
---------------------------------------------------------------------------------------------------------------------------------------
Sept. 26th 2006
Hello all,
I use Visual Studio 2005 Standard. I would like to know the best way that I can create Sql Server 2005 Express databases visually since VS2005 Std. does not allow me to do it.
Any help is appreciated and thanks in advance,
- Noble Bell
I'd be interested in knowing how VS doesn't allow you to create a database. What error are you getting?
There are two ways to create databases, depending on your goal:
To just create a database on your server, do the following:
Open the Server Explorer
Right-click on Data Connections
Click Create New SQL Server Database
Specify Server Name and Database Name
Your database will be created and you can start working with it.
Embed a database in your project:
On the Project menu, click Add New Item.
Select SQL Database from the list and give it a name.
Click OK
This will run you thorugh a wizard to create the database.
If your having problems doing either of these, you may not have SQL Server installed on your computer or VS might be pointing to the wrong Instance Name. Check out the Option dialog under Database Tools:ata Connection and verify that the correct instance is specified.
- Mike Wachel - MSFT
---------------------------------------------------------------------------------------------------------------------------------------
I am trying to create a similar project and I also recieve an error while trying to create a database...
"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could Not Open A Connection to SQL Server."
Now let me explain what i am trying to do ...
I am trying to create a web interface for the data that I want to store in the SQL database. I have installed VS2005 & SQL Server Express 2005 on my local machine. I want to develope this project on my local machine and then transfer it to a server once i have finished the project.
If i am doing this all wrong, please let me know !
Hello all,
I use Visual Studio 2005 Standard. I would like to know the best way that I can create Sql Server 2005 Express databases visually since VS2005 Std. does not allow me to do it.
Any help is appreciated and thanks in advance,
My understanding is that at installation of all but the Express edition, there is no choice but to have VS2005 installed as well. If this is true, can VS 2005 at least be uninstalled after a different debugger is enlisted?
View 7 Replies View Related
Hi,
as I'm relatively new to Sql Server Express, I have a few questions regarding best practices for data handling.
In my ASP.net Application I thought it might be of high value to create the database as mdf file in my vs2005 project,
so I could easily copy the database with the project.
Now inside VS2005 I have the problem of not being able to create any SQL Statements other than queries. For example simple create table statements and such seem not to be possible if I don't want to use the designer.
So I attached the mdf file to my Sql Server Express in Sql Management Studio Express.
But here I seem not be able to detach the file again when I made some changes. Only option is to delete the whole thing.
So my questions are:
1. Is it somehow possible to send simple sql statements to a sql server express database from Visual Studio 2005?
2. How can I detach an mdf database file from Sql Server Express once I have attached it with Sql Management Studio Express?
3. Should I use a different approach to my problem?
thank you all in advance
Hi all,
I couldn't debug SQL Server by "Step into Stored Procedure" on Server Explorer of VS2008 (or VS2005) to SQL 2005 Developer on remote Windows Server 2003 machine, it allway issue exception "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"
1) The environment:
The Client: Windows XP SP2 (WORKGROUP)
Visual Studio 2008 (or VS2005)
The SQL Server Machine: Windows 2003 Server Sp1 (DOMAIN)
SQL Server 2005 Developer
2) User account and Permission login:
I create the same user account for both Client and Domain Server with the same password, i also add that user to "Administrators" group in both machine.
At the SQL Server on Server machine, i added that account to ServerSecurityLogin with 'sysadmin' role already
3) Connection and authentication:
I used "Windows Authentication" for my connection to SQL server, and i checked sure my account of the connection by SQL command
SELECT SYSTEM_USER,
IS_SRVROLEMEMBER ('sysadmin')
4) Firewall:
I checked firewall like MSDN helping (i also tried to test by turn off firewall in both machine)
5) Visual Studio Remote Debugger:
I read "How to: Enable SQL Server 2005 Debugging" on MSDN with comment "The SQL Server can run on the same machine as the application or on a remote machine. If you are debugging T-SQL code only, then no remote setup is required."
so i didn't config Visual Studio Remote Debugger any thing.
Note: If i "Step Into Store Procedure" at Server locally, it works okey, so on at my PC client locally. But if i move debugging from my client to my Server, it occur error "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"???
If i execute store procedure on Server Explore, it works okey!
Please help me to find out what problem is???
Thanks,
Haiasc
Hi Guys,
Hope you don't mind. I have put this in a different forum and although I appreciate the help, I'm not getting the answers I need and I am running out of time.
I have developed a web app in Visual Studio 2005. When I choose "view in browser" default.aspx from within Visual Studio it works perfectly. If I go directly to Internet Explorer and type in http://localhost/testapp it gives me an error of:
"Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur."
This is because in IIS Virtual Directory for TestApp if I choose the asp.net tab and the choose "Edit Cofiguration" Button in the Connection String Manager LocalSqlServer is set to "data source=.SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
Which is making it use SQLExpress. If I Type "http://localhost:1323/testapp" it works because SQLExpress is still running. I want to be able to type "http://localhost/testapp" and it uses Sql Server 2000 How do I get it to do that.
I appreciate any help you can give.
Best Regards,
Steve.
Steve
Steve
Can these two exist side by side? I have SQL Server 2005 (possibly installed when I installed Orcas beta 2?). Now I cannot connect to SQLEXPRESS with error Cannot Login to Default DB - error 4064. Please help!!
Neal
I have a small ASP.NET 2.0 that uses an instanse of SQLExpress. The connection string looks like this:
<connectionStrings>
<add name="DatabaseConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
It works fine when I use it in file system. When I copy it to the server ( IIS6 on Windows Server ) it gives me an error:
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 tried changing the path to the local path on the server but it did not help.
Any help would be greatly appreciated.