I am currently working on a project and I am hosting it on my IIS to test it every so often but now i have an issue:
When i run in debug mode with this connection string:
Data Source=.;AttachDbFilename=c:New folderdbname.mdf;Database=dbname;Trusted_Connection=Yes;
everything works fine and i can access the database but once its published onto my iis it doesnt find the database?
Is it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"? I'm working with another developer on a project and it's getting annoying having to have 2 different version of web.config because he is using SQL Server 2008 and (local) works, but I can't seem to get it to work with SQL Server 2008 Express locally. The database is located on the same computer as the .NET code in case that matters.
View 2 Repliesi have designed a simple login page in VWD(login.aspx) . I have also added the connection to database option. Now i am stuck with adding connection strings in the web config file and also adding namespace.
View 2 Repliesbe it's a wrong place to ask the following question. Sorry for that. Our hosting provider has recently upgraded their database server from Sql Server 2005 to 2008 and I'm getting errors to connect with remote server from my development machine. Error Message "Invalid connection". Tried to find solution on net but couldn't find it.I'm using .Net 1.1. Though we've updated versions 2.0,3.5 & 4.0 but due to some certain circumstances I've no way to update it. It's a web based project. The following connection string works fine for Sql Server 2000 & 2005 but not for 2008.<add key="ConnectionString" value="Data Source=Remote Server's domain name;Initial Catalog=database name;User ID=user name;Password=surround;Persist Security Info=True;Pooling=false;Connect Timeout=45;" />Here Remote Server's domain name indicates to remote db server like: test.mysite4now.comdatabase name for example: test_surrounduser name like test_surroundpassword: surround.Can anyone inform me what's wrong with the above connection string to connect to Sql Server 2008.
View 9 Repliesi have created a website and i have published into a server whose connection string is specified in the connection string
Now i am sending the published files to some company.
If they just change the connection string of web.config to their server, will it work?
I have a new server that I am attempting to deply my very first asp.net website on. I have installed SQL 2008 r2 and loaded my DB on it. I am able to access the server/DB through Visual Stuidio. At least I know i can call it from the webserver to my local PC.
For some reason I just cant get my we.config's connection strong right. It might even be the <provider> info that I have wrong. I am just too inexperienced to know for sure. My Web.Config is very short so I will post all of it here.
-- Code is posted at the end --
How do I modify my local project to use my webservers DB instead of the standard SQL Express DB? The only connection string
Machine.Config that points to the sqlexpress database. Again I lack the experience to know how to do this. I am using Visual Studio 2010 and SQL Server 2008 r2 on my local pc.
[Code]....
When I try to encrypt the "connectionStrings" section in the web.config file of my asp.net web application on Windows Server 2008, I'm getting the following error:
Administration utility (2.0.50727) to install and uninstall ASP.NET on the local machine. Copyright (c) Microsoft Corporation. All rights reserved. Note: This utility has limited capabilities on the Windows Vista operating system. It is recommended that you use the "Turn on or off Windows features" option of the "Programs" component of Control Panel to install or remove ASP.NET. It is also recommended that you use the IIS Manager component or the Appcmd.exe tool to configure ASP.NET applications.
The above information is followed by the list of valid options to aspnet_regiis.exe.
The command that I've used is:
aspnet_regiis.exe -pef "connectionStrings" "C:Usersuser1DocumentsMywebsite" -prov "DataProtectionConfigurationProvider"
But, the same command is working fine when used on a Windows Server 2003 machine. The problem is occurring only on Windows Server 2008 with IIS7.
After I installed Visual Studio 2008 Standard edition, then I upgrade "SQL Server Express 2005" to "SQL Server Express 2008 SP2". Process upgrading SQL Server Express 2008 was going succesfully (none of the process was fail).
But when I create a New Website I could not add a new item "SQL Server Database" into my website file. Because Visual Studio always rejected any new "SQL Server Database" by giving message below (underline):
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
I have created a web site in Visual Web Developer 2008 Express Edition. I have created database using SQL Server Express. The web site works good. I have hosted the web site, then getting error in connecting to database.
The connection string is
<
add
name="QkINDUSConnectionString"
connectionString="Data
Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|QkINDUS.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient"/>
know what is the correction i need to make in ConnectionString ?
I would like to use both of the connection strings in the same web.config file how can I do this I tried this yesterday it worked I called it a night, then this morning I got this. The error being on line: 10 Parser Error Message: The entry 'ApplicationServices' has already been added.
Line 8: <add name="ApplicationServices"
Line 9: connectionString="Data Source=Mysource;Initial Catalog=travelatlantic;User ID=MyID; Password=MyPassword;" />
Line 10: <add name="ApplicationServices"
Line 11: connectionString="Data Source=MySource;Initial Catalog=travelatlantic2;User ID=Myid; Password=MyPassword;" />
Line 12: </connectionStrings>
i have installed SQL server 2005 Server & Clicent in My PC. now i want to install SQL server 2008 Express Edition.
when i try to install it it gives an Error as below.
Rule "SQL Server 2005 Express tools" failed.
The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.
I am developing a C# VS 2008 / SQL Server 2005 Express website application. I have tried some of the fixes for this problem but my call stack differs from others. And these fixes did not fix my problem. What steps can I take to troubleshoot this?
System.Data.SqlClient.SqlException was caught
Message="Conversion failed when converting datetime from character string."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
LineNumber=10
Number=241
Procedure="AppendDataCT"
Server="\\.\pipe\772EF469-84F1-43\tsql\query"
State=1
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ADONET_namespace.ADONET_methods.AppendDataCT(DataTable dt, Dictionary`2 dic) in c:Documents and SettingsAdminMy DocumentsVisual Studio 2008WebSitesJerryApp_CodeADONET methods.cs:line 102
And here is the related code. When I debugged this code, "dic" only looped through the 3 column names, but did not look into row values which are stored in "dt", the Data Table.
public static string AppendDataCT(DataTable dt, Dictionary<string, string> dic)
{
if (dic.Count != 3)
throw new ArgumentOutOfRangeException("dic can only have 3 parameters");
string connString = ConfigurationManager.ConnectionStrings["AW3_string"].ConnectionString;
string errorMsg;
try
{
using (SqlConnection conn2 = new SqlConnection(connString))
{
using (SqlCommand cmd = conn2.CreateCommand())
{
cmd.CommandText = "dbo.AppendDataCT";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn2;
foreach (string s in dic.Keys)
{
SqlParameter p = cmd.Parameters.AddWithValue(s, dic[s]);
p.SqlDbType = SqlDbType.VarChar;
}
conn2.Open();
cmd.ExecuteNonQuery();
conn2.Close();
errorMsg = "The Person.ContactType table was successfully updated!";
}
}
}
From the last few days I am struggling with the error
"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."
I hav created an asp.net web application with membership shcema. It works fine an my developement machine but when I published it on my web server.
Would something be missing, not working, or confusing if I do this? First, install SQL Server 2008 Standard, and SP1. Then, install Visual Studio 2010 Professional, unchecking SQL Server 2008 Express option. Or would I need to fix any configurations afterwards?
View 1 RepliesI wrote my first app in VB 2010 ASP/SQL. Runs perfectly in VS environment.
I then publish it to 2008 Server using Windows Authentication. The only App Pool it will start in is ASP.NET 4.0 Integrated....Classic will not work.
Starts out OK and then when the program tries to access SQL I get the following:
[Code]....
HTTP Error 500.24 - Internal Server Error An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.
[Code]....
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 RepliesMy set up is as follows
IIS + SQL Server Express running on the same machine.
SQL Server Express has named pipe connections.
IIS hosts an ASP.Net website(v3.5)
ASP.Net site has web config entry to database using integrated security.In regard to this, how are the connections between the ASP.Net app. and SQL Server express handled? Does each user connect using the same login to SQL Express (think its NETWORK-SERVICE)? If 2 people hit the same web page at the same time how many connections are opened to SQL Express? Is it up to the setting in connection pooling? E.g. if connection pooling is set to 10 then in this example 2 connections are opened?Or is it that only one connection is used and users must wait for the previous user's webpage to finish all database operations before their request can be processed.
i published an application on windows server 2008 and IIS 7 i am facing a problem when user are trying to access the server or the web application in address they put ip address of the server /application a pop up screen asking for username and password problem IIS on windows server 2008 ..the server is configured it s making me crazy it s asking users for username and password
View 3 RepliesI have created a web app using Visual Studio 2008 Express Edition and have come to the point where I need to publish the site onto my server (which is running window server 2008). I found that the publish function is not limited in the express edition, so published the app to a local file and FTP'd the contents across to my server. I then setup a website through the servers IIS manage and pointed it to the folder containing the FTP'd files.
My question is, how do I run the app? Do I need to point to a specific file?
I have tried to view a number of the files in browser directly from the IIS but keep getting the same standard connection error i.e. "Internet Explorer cannot display the webpage"
I have never used IIS Manager before and I can't find a resource which gives me a step by step guide to setting up a new site which has been created by Visual Studio 2008 Express Edition, are there any config changes needed.
How to put an OleDB Connection String in Web.Config I wrote the following code but getting error
Code:
<appSettings>
<add key="ConnectionString"
value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/App_Data/AMS.MDB")" />
</appSettings>
Getting error while concatenating a string Data Source=" & Server.MapPath
give me an example of the proper connection string for getting VS 2010 to use the aspnet database on my SQL 2008 server? The db is there, I just can't seem to get connected. Server name GUNSITESQL, mixed security. I want to logon with a SQL user logon id, the db name is the default aspnet.
Currently, the web.config file is the default.
Can you use a session variable in a web config connection string? So instead of:
Code:
<add name="ConnectionString2" connectionString="Data Source=ora;Persist Security Info=True;User ID=SA;Password=PASS;Unicode=True"
something like this:
Code:
<add name="ConnectionString2" connectionString="Data Source=" & Session(DB) & ";Persist Security Info=True;User ID=SPAR;Password=;Unicode=True"
How do I call the connection string in the webconfig file from a web form?
View 4 RepliesAfter reinstalling Visual Web Developer 2008 express a few times I still don,t have design view just source view.
View 3 Replies