Server Explorer and SQL Server
-
I posted this question in the General Discussions forum yesterday because I didn't realise this forum existed till now. Basically my problem is this. I have installed an instance (the default) of SQL Server 2000 on a computer in our domain. Howerver when I connect to a database on this server using VS's Server Explorer, I don't get any of the nice options like "Edit Stored Procedure", "New Stored Procedure" etc etc. However, I have installed MSDE 2000 on other computers on the domain and I have no problems doing that sort of stuff with them. I doubt the problem is a database credentials issus since, I use exactly the same credentials through an Access Project to access the database to modify its structure. To further confirm this I even enabled SQL authentication and logged in as 'sa', to no avail. Another thing that I have noticed is that when I right click on the connection under 'Data Connections', I don't have the option to "Modify Connection" (its greyed out) like I do with other connections to other servers on the domain. Also the connection doens't list the "Database Diagrams" or the "Functions" sub folders. Its almost as if VS is using a different driver to connect to this SQL Server 2000 as opposed to the other MSDE 2000 machines on the network in the domain. Its rather annoying as you can imagine, but I have no idea what could be causing it. Something in VS.NET tells it that it can't edit the database etc. I even installed VS's remote components and enabled remote debugging on the server to see if that would fix it, all to no avail. Has anyone else experienced something similar. I've googled away and no one else seems to have this issue. Thanks in advance, Andy
-
I posted this question in the General Discussions forum yesterday because I didn't realise this forum existed till now. Basically my problem is this. I have installed an instance (the default) of SQL Server 2000 on a computer in our domain. Howerver when I connect to a database on this server using VS's Server Explorer, I don't get any of the nice options like "Edit Stored Procedure", "New Stored Procedure" etc etc. However, I have installed MSDE 2000 on other computers on the domain and I have no problems doing that sort of stuff with them. I doubt the problem is a database credentials issus since, I use exactly the same credentials through an Access Project to access the database to modify its structure. To further confirm this I even enabled SQL authentication and logged in as 'sa', to no avail. Another thing that I have noticed is that when I right click on the connection under 'Data Connections', I don't have the option to "Modify Connection" (its greyed out) like I do with other connections to other servers on the domain. Also the connection doens't list the "Database Diagrams" or the "Functions" sub folders. Its almost as if VS is using a different driver to connect to this SQL Server 2000 as opposed to the other MSDE 2000 machines on the network in the domain. Its rather annoying as you can imagine, but I have no idea what could be causing it. Something in VS.NET tells it that it can't edit the database etc. I even installed VS's remote components and enabled remote debugging on the server to see if that would fix it, all to no avail. Has anyone else experienced something similar. I've googled away and no one else seems to have this issue. Thanks in advance, Andy
Hi! Are you using the professional edition of VS .NET? The professional versions Server Explorer can only connect and work with MSDE 2000 Databases. If you want to modify SQL Server 2000 Databases you have to use VS .NET Enterprise or whatever it is called. Cheers HTH Martin "Situation normal - all fu***d up" Illuminatus! http://www.martin-haesemeyer.de