Hi all,
I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.
Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.
For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.
If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".
Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?
Any help on this issue would be greatly appreciated.
Thanks.
I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.
In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
Hi Mike,
As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.
The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.
I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?
I haven't had much experience with MS SQL so please bear with me :)
Thanks for your prompt reply and help.
|||Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.
In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.
Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.
I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.
Regards,
Mike Wachal
SQL Express team
Hi Mike,
Thanks for that. I'll try and post up some questions on the asp.net forums. 
No comments:
Post a Comment