DataSource Controls :: MS SQL Server ... Version / Installation And More Importantly Web Connection
Jan 5, 2011
I am having trouble installing SQL Server on my system ... it appears to install ok but when I try to connect it using Visual Web Developer Express 2008 it will not connect and mentions something about versions. I downloaded the Northwind database to carry on with the tutorials .. this also asked me to download the MS SQL 2000 version which I tried and this also did not work, other versions include 2005 and 2008. When I tried to open the program through the programs file from "Start Menu" only the configuration manager folder is there.
I have also tried to install the trial version from the website but to no avail. Each time I have restored to factory settings on my laptop and it still fails to connect. I notice that when I restore to factory settings there are loads of icons where the uninstall window lists all of the programs and there is still SQL Server 2008, lots of Icons. I think that version 2008 came with the laptop as it is a business sony vaio sr vgn-sr46gd model with vista business.
View 1 Replies
Similar Messages:
May 22, 2010
I have Visual Studio 2008 installed on this workstation with SQL 2000, 2005 Express, 2008 Express and I think 2008 R2 (not sure if that is a version itselve or not)
I will call that workstation HOME
I created some tables in SQLEXPRESS through VS2008.
I worked on this project on another workstation that I just installed VS2008 annd SQLEXPRESS 2008 and I know that was R2
Installed Visual Studio 2010 trial edition between the thiem I made the tables on HOME and tonight for the first time since that install
I am now getting the "cannot be opened becuase it is version Version 661. This Server supports version 655..."
What to do now?
I can opened SQLExpress 2008 management studio and it is running.
So is my SQL 2000. The problem seems to be that after the VS2010 install neither VS2008 or VS2010 can connect to the SQLExpress 2008
What do I do now?
I can't remove sql 2000 because it is tied to several 3+ gig databases that will not work in Express.
View 2 Replies
Feb 6, 2010
Cant get the connection from asp to sql server (to any db) I got installed asp express 2008 and sql 2008 express(with SQL MANAGEMENT STUDIO) installed on my machine. On the services.msc The sql server express the status is started. The sql server agent status is disabled and don't have the option to start. The sql server explorer status is disabled and don't have the option to start.
View 6 Replies
Jul 21, 2010
We recently launched a new web site.there are roughly ~150 users active during peak hours.During peak hours,we are experiencing an issue every few minutes,the exception text is listed below.
System.Web.HttpUnhandledException:
Exception of type 'System.Web.HttpUnhandledException' was thrown.
---> System.Data.SqlClient.SqlException: The client was unable to establish a connection because of an error during connection initialization process before login.
Possible causes include the following:
the client tried to connect to an unsupported version of SQL Server;
the server was too busy to accept new connections;
or there was a resource limitation (insufficient memory or maximum allowed connections) on the server.(provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
Our data access layer calls various DataTableAdapters using the following syntax.
EDIT
Yes, da is the name assigned to the DataTableAdapter. There is no connection.Open() because the DataTableAdapter takes care of all that, right?
using(TheDataLayer.some.strongly.typedNameTableAdapters.suchAndSuchTableAdapter da
[code]...
The connection string looks something like:
<add name="MyConnectionString"
connectionString="Data Source=myDBServerName;Initial Catalog=MyDB;User ID=MyUserName;Password=MyPassword"
providerName="System.Data.SqlClient" />
I'm trying to rule the problem being in Code.Is there anything "simple" that can be done to minimize this issue?
View 6 Replies
Jun 1, 2010
How to find which version of the Sql Server install into your system,I am running Windows Vista Home Premium(32 bit operating system) , when I try to install Sql Server 2005 Stand edition on my laptop ,it's shows some compatibility issue.
View 6 Replies
Apr 1, 2010
I'm trying to implement a regular ol' out of the box asp.net login system on SQL Server for the first time ever, and it's giving me way more grief than I ever imagined. Everything works great on my local asp.net testing server, but I can't get it working on the web server. I just get the generic- Server Error in '/' Application. A tech at my host mentioned that he thought that it was because I was using an ASPNETDB.MDF file created in SQL Express 2008 on a SQL Server 2005 server. I makes sense but I've seen a half dozen or more possible solutions in the many hours/days I've spent researching this but I hadn't heard of that one.
View 7 Replies
May 17, 2010
i am trying to install SQL Server R2 on my windows 2003 server (I downloaded the x64 version) but on the installation directory, just before i click next, to get the error, the path is as follows: C:ProgramFiles(x86)Microsoft Sql Server im not too sure if thats the problem though, just guessing, since i dont know anyother problem, and its a new server. I also tried multiple server restarts and still got the same error.
View 6 Replies
Sep 4, 2010
I am using sql server fulll edition.any idea how should I solve this issue, I search on net but not found any helpful answer.
View 4 Replies
Nov 15, 2010
i am trying to create connection using OLEDB connection in my app. but i am not able to create the connection as in datasource i want to use Server.mappath, but cudn't find the right method to use it. i am trying to make connection with Access database file. following is code i have tried:
string path = Server.MapPath("~/uploadaccess/Production.mdb");
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb")&";";
and also
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path&";");
and tried this
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb"));
and this is the error i am getting:
Operator '&' cannot be applied to operands of type 'string' and 'string'
View 3 Replies
Mar 2, 2010
im using windows 7 home premium-64 bit,when i want to install sql server its not asking for mixed mode its directly creating windows authentication mode but i want to use sql server authentication mode,when im installing im unable to see any mode selection?
View 4 Replies
May 20, 2010
I have never created my own solution before now. I have always modified existing solutions and know how to do it. For some reason, this new solution isn't connecting to my SQL server correctly.
I am using VWD 2008 Express Edition.
I have MSSQL 2008 Developer Edition.
I have used aspnet_regsql.exe to create the tables in my SQL DB.
I have added the following to my webconfig:
[Code]....
But for some reason, when I try to use the Web Site Administration Tool it thinks it is not setup.
What am I missing?
View 1 Replies
Mar 5, 2010
Not sure why it works if i connect to SQL 2005 on another server, but now that i have SQL Express on the same server as the pages, im getting the following error: I have attached my connection string within my web.config and also how its being called within the code behind. Now this page was written by another programmer some time back.. so not sure if the method he used to do this is the best or only way. But i have connected to other SQL database with other applications with alot less code.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error: Line 131:
Line 132: //connect to this sql server
Line 133: c.Open(); -----> this is the line it complains about.[Code]....
View 8 Replies
Jan 8, 2010
I have an application with a few dbml files to connect to several sql servers in order to import data from one to another using Linq to SQL.
There are 2 connection strings with integrated security and in one I provide user ID and password.
It all works great in the development workstation. I've then wrapped the dll project and deployed the asp.net application to a test server. Then, when I tried to run the application to import the data, I got a connection exception:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I figured out after some debugging the problem is with the DataContext whose connection string is the one I provide user ID and password. Now, the funny part is that the same connection string works if I create a udl file and test it. And again the same connection string works with my development workstation.
View 4 Replies
Apr 13, 2010
I try to connect sql server 2005 through OBDC connection bt i face a error, i face this error
ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
OdbcConnection conn = new OdbcConnection("Driver={SQL Server};Server=test;UID=sa;PWD=java;");// test is my ODBC connection name
string query = "INSERT INTO test VALUES ('" + textBox1.Text + "','" + textBox2.Text + "')";
OdbcCommand cmd = new OdbcCommand(query, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Inserted.");
}
finally
{
conn.Close();
}
View 1 Replies
Feb 4, 2010
My website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
View 11 Replies
Feb 3, 2010
i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
View 2 Replies
Jul 15, 2010
My question is let's say I have "MS Windows Server 2003 R2 with IIS v6".And in this server, I have .Net Framework 1.0 (For my VS2003 Web Sites),
.Net Framework 1.1 (For my VS2005 Web Sites) and .Net Framework 2.0 (For my VS2005 Web Sites).And now I have a web project written in VS2008 with framework 3.5. And I'm planning to put this project in this local server (as Intranet site).
View 2 Replies
Oct 14, 2010
i am using sqlserver 2008
in my computer, sql server name is "LOCALHOET-PC" AND SECOND ONE "LOCALHOST-PCSQLEXPRESS"
I have write a code in my software like
SqlConnection conn;
conn = new SqlConnection("Data Source=LOCALHOST-PC;Initial Catalog=n4netsALT;Integrated Security=sspi");
conn.Open();
and it is working working smoothly in my computer
View 2 Replies
Apr 6, 2010
I would like to do a connection of asp.net page with Sql Server. Here I would like to read the Windows user account name and pass in the connection.The connection should be Windows authentication. IIS server and Sql server are installed in different machine. Here I am able to connect locally, When I am running from server, It takes windows account of Server.
so i can read local account(Where user is accessing the web application) and make windows authentication sql server connection.
View 3 Replies
Mar 3, 2010
I am trying to use Windows Authentication in my asp code. I have read / tried all answers on the web but couldnt my page to connect to sql. I m using classic asp.
My conn string looks like :
OCONN.OPEN ("PROVIDER=SQLOLEDB; DATA SOURCE myserver; INITIAL CATALOG=nrth; Integrated Security=SSPI; trusted_Connection=yes")
but I mgetting error
Microsoft OLE DB Provider for SQL Server
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.error '80004005'
View 6 Replies
Jun 29, 2010
How to connect to different data providers(Say Oracle and SQL Server) using single connection string?
View 1 Replies
Apr 7, 2010
In my DAL i have more than 100 methods/Function, each and every method am opening the sqlconnection and closing the connection, this is taking too much of time to establish the connection at every time. So what i expect is one common class will create the SqlConnection that will check if the connection is Broken or Closed then create the connection again else return the connection, how to do this(Also i would like to apply ConnectionPooling).
View 7 Replies
Jun 7, 2010
I think I did something stupid recently. I tried out the new vs2010 and probably changed settings to the newer version of the .net framework. My asp.net pages are working normally as before locally on my machine, but after I uploaded my web.config file to my ISP, the same pages are not working online.The version of asp.net my ISP has is 2.00.50727. I can upgrade that to 3.0 for an addional cost, but how do I revert back to my previous version, is this done in the wetb.config file perhaps?
View 3 Replies
Jan 13, 2011
i have created a pluIn(setup) for IE. this plugin add in IE addOns.this pluIn(setup) installation and uninstallation is working perfect. now i want use a webservise that check version of my computer plugin and server computer plugIn(setup).if both version are different then ask for updation of PlugIn(setUp).if i click on yes then it update my end PlugIn(setup).
View 1 Replies
Apr 23, 2010
I am using VS2008 under WINXP, I have a project which the ASP.NET version is set to 3.5.
The code: Response.Write(System.Environment.Version.ToString) prints out 2.0.50727.3603
After checking in http://en.wikipedia.org/wiki/List_of_.NET_Framework_versions I found out that the ASP.NET version is 2.0 SP2.
How can I set my project to ASP.NET 3.5 ?
View 9 Replies
