deploying server without visual studio and sql server -- only framework 3.5
-
I am creating a simple remoting application which uses a strongly typed data set to retrieve data and send it to the cliet when required. This works fine when I have everything installed on my machine. Now I am trying to deploy the sever on a machine on my network ... but i have installed .net framework 3.5 on that machine ... no sql server or visual studio .. how can i make it work .. also, i tried to create an odbc for my sql server on the other machine .. but was unable to do that .. anyone any idea??
-
I am creating a simple remoting application which uses a strongly typed data set to retrieve data and send it to the cliet when required. This works fine when I have everything installed on my machine. Now I am trying to deploy the sever on a machine on my network ... but i have installed .net framework 3.5 on that machine ... no sql server or visual studio .. how can i make it work .. also, i tried to create an odbc for my sql server on the other machine .. but was unable to do that .. anyone any idea??
vishwjeet wrote:
Now I am trying to deploy the sever on a machine on my network ... but i have installed .net framework 3.5 on that machine ... no sql server or visual studio .. how can i make it work ..
Why would you need Visual Studio on a production machine? You need to cleary explain you problem.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
vishwjeet wrote:
Now I am trying to deploy the sever on a machine on my network ... but i have installed .net framework 3.5 on that machine ... no sql server or visual studio .. how can i make it work ..
Why would you need Visual Studio on a production machine? You need to cleary explain you problem.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
vishwjeet wrote:
Now I am trying to deploy the sever on a machine on my network ... but i have installed .net framework 3.5 on that machine ... no sql server or visual studio .. how can i make it work ..
Why would you need Visual Studio on a production machine? You need to cleary explain you problem.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
I would like to make one point clear .. Whenever my server is on vista machine ... nothing works ... but when i make my xp machine a server .. the same code works fine ... so this time .. im making my server on xp machine with .net fw installed .. but my sql server is on vista machine .. so i need to access this sql server through n/w as i cannot install sql server on my xp machine .. is my problem clear from this ..???:confused::confused:
-
I would like to make one point clear .. Whenever my server is on vista machine ... nothing works ... but when i make my xp machine a server .. the same code works fine ... so this time .. im making my server on xp machine with .net fw installed .. but my sql server is on vista machine .. so i need to access this sql server through n/w as i cannot install sql server on my xp machine .. is my problem clear from this ..???:confused::confused:
Have you installed SQL server in mixed mode? If so, then just exempt the sqlbrowser and sqlserv.exe files from your firewall. Create a new login to your sql server and also add that user to the database you want to connect. you will get those files here : drive:\Program Files\Microsoft SQL Server\MSSQL.XX\MSSQL\Binn\sqlservr.exe drive:\Program Files\Microsoft SQL Server\XX\Shared\sqlbrowser.exe Now connect using SqlAuthentication using the userid and passwornd, and you are done. :-D
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.