Showing posts with label downloaded. Show all posts
Showing posts with label downloaded. Show all posts

Friday, March 30, 2012

problem in Installing SQl Server Management studio express _ (ctp)

I'm very new to MS SQl Server, i Downloaded MS SQl Server express edition, the problem is i can't deal with it, when i downloaded (Microsoft SQL Server Management Studio Express - Community Technical Preview (CTP) November 2005) every time i try to install it , it give me error message says "The system administrator has set policies To Prevent this installation"
How can i over come this problem and install this interface to be able to deal with sql server?
is there any other software can do this job "making interface for the sql server express edition"?
ThxI downloaded the Nov CTP as well of the Management studio, but can't go beyond this error.

This installation package cannot be installed by the windows installer service. You must install a windows service pack that contains a newer version of the windows installer service.

I have Windows 2000 SP4 and also the Windows Installer 3.0, MSXML 6.0 Still Sad

Thanks in advance for any help.
Kalyan.|||Go to the following link an install the latest update to Windows Installer: http://www.microsoft.com/downloads/details.aspx?FamilyID=889482fc-5f56-4a38-b838-de776fd4138c&DisplayLang=en

Cheers,
Dan|||hi,
I have the windows installer 3.1 but yet i can't install (TCP) managment studio keep getting the same error "administrator has set policies to prevent this installation"
additional hint : - i use windows xp_sp2 - when i used to counter this problem i downloaded MS Visual Web developer express 2005 and i was able to connect to sql server, but really i'm new to sql and i need to see interface to be able to learn it at least|||Sorry for the messege, i downloaded the SQl Server Management Studio Express Again and when i tried to install it , it worked seems it was a problem in the first time i downloaded it something was wrong in it
anyway thx guys

Wednesday, March 28, 2012

Problem in ERD creation in sql server management studio

I have downloaded adventurework database intall it then configure the databases in managemnt studio and then make a ERD of the db all works fine.

Then I have intall asp.net 2.0 starter kits.
1,Club Starter kit
2,Commerce Starter Kit
3,eBay Selling StarterKit
4,Jobs Site Starter Kit
5,Personal Site Starter kit
6,Time Tracker Starter kit

install them and configure the databases in managemnt studio.all thing works fine but when I create erd of any of these databases I get message

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

I have read the microsoft kbarticle but really no help.
If any body have gone through same situation and resolve it then please reply.

Thanks
Kamran Shahid
Software Engineer(MCSD.NET)
Progressive Systems (Pvt) Ltd.
Karachi,Pakistan
Tel :92-21-5675294-96
Cell :920304-2212616
Email :kamranshahid@.netprosys.com
:kamii47@.hotmail.comRight-click on the database in MS, select properties, and on the files tab, specify an owner for the db.|||When I check to database properties then file option it has the same owner that is (KAMI\Administrator) as of the databases (adventureworks,nortwind,pubs) whos ERD I am able to and have created.|||

That issue was also discussed here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=228352&SiteID=1

sql