Last post Jan 05, 2011 07:21 PM by email@example.com
Jan 05, 2011 03:32 PM|PhoenixSolutions|LINK
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.
I am really confused and am desperately trying to get it fixed ... HELP!!!!
.NET SQL Server 2000
Access database query string
"SQL Select and Update Where "
Access databaseto SQL
.NET SQL Server 2005 storeprocedure
"SQL Server" "SSIS" ".Net" "SQL" "ASP"
sql 2008 express
"ASP.NET and SQL Server
Jan 05, 2011 07:21 PMfirstname.lastname@example.org|LINK
First question I ask is which version of SQL Server did you install? Also I would recommend you install SQL Server Management Tools (version 2008), this will give you control over exactly how the database service is setup and configured.
Once installed verify that instance is running through "SQL Server Configuration Manager" with correct login permissions etc. Next would be to open "SQL Server Management Studio" and attempt to attach the database to the running Server instance.
This should provide more details as to why you are recieving these issues. Another thing to check out is in the Configuration Manager that Names Pipes & TCP/IP are also enabled so your Visual Studio can connect directly to the Database Server.