Last post Apr 18, 2018 09:14 AM by PatriceSc
Apr 17, 2018 08:21 PM|ayoking|LINK
Hello I'm trying to open my ASP.NET website on another computer but I keep getting errors and in the properties it says the server state is closed.
Could someone please help me figure it out?
I created the server in Microsoft SQL Server Management.
I really need help on this issue thanks.
Apr 17, 2018 11:04 PM|shockemc|LINK
More information would be helpful here, did you have a data connection to a server somewhere? Also, how are you opening the project? It is best to use File > Open > Website as this does not require the sln file and will generate one for you.
Apr 18, 2018 01:35 AM|Edward Z|LINK
>> I keep getting errors and in the properties it says the server state is closed.
It seems your web site fail to connect the SQL Server. I suggest you check whether your SQL Server is running from the SQL Server Management.
Where did you develop Asp.net website? I suggest you running it from development, will you receive any error?
Apr 18, 2018 07:51 AM|ayoking|LINK
So, on the 2nd computer Im trying to run it from (my laptop). I should install SQL Server Management and transfer the database files?
I developed the ASP.NET website in visual studios.
Apr 18, 2018 08:01 AM|Edward Z|LINK
>>on the 2nd computer Im trying to run it from (my laptop). I should install SQL Server Management and transfer the database files?
How do you open the web site? Do you host the Asp.Net WebSite on your develop computer and try to access the site by entering URL in the web browser?
Or, do you mean that you open the Asp.Net project from VS on the 2nd computer?
If it is later, there is no need to install SQL Server, but you need to make sure that the 2nd computer could connect to the development computer since your database is on the development computer, and your connection string should be target the development
computer instead of localhost.
Apr 18, 2018 08:26 AM|ayoking|LINK
Its a website I developed for a project that Im supposed to demo, I unfortunately developed it on SQL server management LOCALHOST/EXPRESS on my main PC.
Sever details on main PC.
Server Details on Laptop
Apr 18, 2018 08:30 AM|ayoking|LINK
Yeah I have a data connection
Apr 18, 2018 08:30 AM|Edward Z|LINK
Do you want to create a new database file in the 2nd PC, or you want to connect the original database?
If you want to connect the original database, change the connection string with ip address instead of localhost.
I am wondering could you connect your database from VS SQL Server Object Explorer in the 2nd PC.
Apr 18, 2018 08:34 AM|ayoking|LINK
No its not tell me connect through visual studio server explorer, I was hoping that is what would happen when I transferred it to my laptop.
The distance of my I'm presenting it from is far from my laptop so I don't think that would work.
Do you know how I can fix the VS server explorer issue or would I just have to download SMSS and copy the databases over on my laptop
Apr 18, 2018 09:06 AM|Edward Z|LINK
There is no need to install SMSS.
You could copy the database to your laptop, and then connect it by follow steps below:
Apr 18, 2018 09:14 AM|PatriceSc|LINK
What if you try .\SQLEXPRESS ?
I believe using localhost goes technically through the network and may require some extra configuration compared with using .\SQLEXPRESS or (local)\SQLEXPRESS (by default SQLEXPRESS is not configured to serve requests over a network).
To be on the safe side, SQL Server Express has been installed on this machine ?