I encountered difficulties with admin login & password before --as in, my client had forgotten the sa password --but I was able to resolve the issue; I "reset" the password using SQL Server Mgmt. Studio Express. Having worked before I tried this method again.
I was able to fix the problem by removing the registry enties for SQL Server under current user. I figured it out after I logged in as a diferent user and was able to open SQL management studio.
Parent columns and child columns don't have type-matching columns." even though both data types are int and worked in MS SQL Server Management studio. Why? and do I need to set this in VS2008 if it worked in the MSSQL Server Management Studio? Edited byVict0rFriday, May 4, 2012 4:39 AM Friday, May 4, 2012 4:13 AM
This file does exist and is in the same directory as SSMSEE.EXE (C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE). Other context menu items "Script table as" and "Properties" work fine.
The other solution, you could change the UAC settings to be minimal (search for UAC in the start bar and select Control Panel –> Change User Account Control Settings) and set to minimal settings. Or you can disable UAC to solve the issue. Then you could install SQL Server Management Studio.
I had SQL Server 2008 and SQL Server Management, so I deleted everything I could except for Visual Basic 2010 Express. If you found my post helpful, please give me a recognition point on the left hand side of my post.
When you install SQL Server you can install it as a default instance or named instance. Only one default instance and a maximum of 50 named instance per server. in your case try install sql server on your local pc and create the database there. i don't think installing named instance on production server is a good idea.
long story short, i need my subscription management to be run from within SQL server, so that all applications can use subscription management features. several of our applications have no access to .Net, and others have a disconnected (web service) based data layer, so placing a .Net based subscription management interface into them is not posible, yet they will need to be able to magage ...
