Error
-
H everyone, I installed Sql Server 2005 and it installed good but when I want to use of it,it shows 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:Names Pipes Provider,error:40 - Could not open a connection to SQL Server)" I get this error when I am tring to : 1- I go to on the Visual studio Data Menu then select Add new Data source then select Database and click Next button then I click New Connection and select Microsoft SQL Server now it want Server name I enter server name and then I went to Select or enter database name but It didnt show any thing to then I select Attach a databse file and enter a file(its extenstion mdf) and when I click ok I got above error Is it possible I am getting this error because I enter wrong server name if yes how can I find correct name of server. Thanks
-
Then you don't need to enter the server name, you can just enter '.' (a full stop), that corresponds to the local server. Note: if you installed SQL Server 2005 Express, then you should use '.\SQLExpress' as the server name. If this doesn't work, check if the SQL Server service is running. Roel
-
H everyone, I installed Sql Server 2005 and it installed good but when I want to use of it,it shows 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:Names Pipes Provider,error:40 - Could not open a connection to SQL Server)" I get this error when I am tring to : 1- I go to on the Visual studio Data Menu then select Add new Data source then select Database and click Next button then I click New Connection and select Microsoft SQL Server now it want Server name I enter server name and then I went to Select or enter database name but It didnt show any thing to then I select Attach a databse file and enter a file(its extenstion mdf) and when I click ok I got above error Is it possible I am getting this error because I enter wrong server name if yes how can I find correct name of server. Thanks
This is probably an error caused by the service not being started.
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
-
This is probably an error caused by the service not being started.
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
Hi Jerry, Its on the memory sqlserver.exe and it shows run but when I tired (I said on the first message) I cant see any databses.but I remove vs2005 and installed again please see my last post to roel_v,Where can I enter sql statements like Query on the Sql2000
-
Then you don't need to enter the server name, you can just enter '.' (a full stop), that corresponds to the local server. Note: if you installed SQL Server 2005 Express, then you should use '.\SQLExpress' as the server name. If this doesn't work, check if the SQL Server service is running. Roel
Hi roel_v, Thanks for your help I remove Vs2005 and Installed again it after install I have these items on the Sql folder at start menu SQL Server Configuration Manager SQL Server Error and Usage Reporting SQL Server Surface Area Configuration Does it install perfect or no? now I can see databses of sql(master,...) on the combobbox that I said at my first message and I can working it but I have a question I cant see Query english and Enterprise how can I eneter statements like createdatabse on the sql
-
Hi roel_v, Thanks for your help I remove Vs2005 and Installed again it after install I have these items on the Sql folder at start menu SQL Server Configuration Manager SQL Server Error and Usage Reporting SQL Server Surface Area Configuration Does it install perfect or no? now I can see databses of sql(master,...) on the combobbox that I said at my first message and I can working it but I have a question I cant see Query english and Enterprise how can I eneter statements like createdatabse on the sql
It sounds to me like you have installed the freely available version SQL Server Express 2005, not the full version of SQL Server, is that correct? By default, unlike the full version of SQL Server, this does not come with SQL Server Management Studio, which is used to create databases and enter SQL queries. You can either open a command prompt and type sqlcmd -S.\SQLExpress -E to get a command prompt from where you can enter SQL statements against your database. Or, you can download the freely available SQL Server Management Studio Express, which gives you a graphical interface to do all this (recommended). Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en[^] Hope this helps, Roel
-
Hi Jerry, Its on the memory sqlserver.exe and it shows run but when I tired (I said on the first message) I cant see any databses.but I remove vs2005 and installed again please see my last post to roel_v,Where can I enter sql statements like Query on the Sql2000
Download the SQL Server Managment Studio.
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
-
Download the SQL Server Managment Studio.
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
-
It sounds to me like you have installed the freely available version SQL Server Express 2005, not the full version of SQL Server, is that correct? By default, unlike the full version of SQL Server, this does not come with SQL Server Management Studio, which is used to create databases and enter SQL queries. You can either open a command prompt and type sqlcmd -S.\SQLExpress -E to get a command prompt from where you can enter SQL statements against your database. Or, you can download the freely available SQL Server Management Studio Express, which gives you a graphical interface to do all this (recommended). Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en[^] Hope this helps, Roel
Thank you yes it was help but I'm sorry to interrupt again I saw your link and I want to donwload "Microsoft SQL Server Management Studio Express" if I download it Can I sure that I will not problem to work with sql 2005(of course my intent is like previous ) ?
-
Thank you yes it was help but I'm sorry to interrupt again I saw your link and I want to donwload "Microsoft SQL Server Management Studio Express" if I download it Can I sure that I will not problem to work with sql 2005(of course my intent is like previous ) ?
-
As far as I know, the only time it will not work is if you have the full version of SQL Server Management Studio installed already, which for you is not the case (otherwise you would not have to install this one.) So, just go ahead and try. Roel
Hi again, I download and install SQLServer2005_SSMSEE it seems like sql 2000 It has query is it like query on the swl2000(of course not excatly) now I have another question I install vs2005 that it has sql server and also install your link do I need to install other things for sql or these are enough. Thanks for your help and your good info
-
Hi again, I download and install SQLServer2005_SSMSEE it seems like sql 2000 It has query is it like query on the swl2000(of course not excatly) now I have another question I install vs2005 that it has sql server and also install your link do I need to install other things for sql or these are enough. Thanks for your help and your good info
-
I guess so. Maybe the next step would be to buy a good book on database programming with Visual Studio? Roel
-
Your answers are helpful for me (I have two book about sql not they are for sql 2000 most for programming database)may I ask if i have any problem on the sql2005 in next? Thank you.:rose:
SQL Server 2005 is fully backward compatible with SQL Server 2000, if that's what you mean, so whatever works on SQL Server 2000 will (in most cases) work fine on 2005. If you want to take advantage of some of the new 2005 features, do some research online or get a 2005 book. Roel