Community discussion forum

VS.NET/sql server installation problem

• • Reply

  4 years ago

  by juicemousezero

  juicemousezero

  Usa, United States

  Joined 4 years ago

  I'm installing VS.NET on my new machine. Almost everything has gone according to plan thus far except for getting this pesky SQL Server to work. It's been a while since I first installed Studio, but I think I remember having the default databases (master, model, et cetera) installed without having to do anything. During my previous installtion of Studio, those databases didn't get installed. Were they supposed to? Plus, when I create an instance of SQL server so as to create a database, the instance gets created but I can't access it (that stupid red X icon wont go away). I've tried every kind of authentication, and none work.
  

  
  I was curious if that might something to do with those default databases for some reason not being installed and if so, how can I get them going? I don't see why they weren't installed. I don't recall doing anything different on this install than the last one, but who knows...
  

  
  thanks in advance..

  Report abuse
• • Reply

  4 years ago

  by tekvaio

  tekvaio

  , United States

  Joined 4 years ago
  I've got Visual Studio .NET 2003 and SQL Server 2000 installed on my XP professional machine.
  
  I create a Data Connection to the SQL Server 2000 Northwind database using Windows NT Integrated security. When I right click on the Table node in the Server Explorer there is no "Design Table" menu item. Likewise, there is no "Add View" for the view node.
  
  I've tried creating a Data Connection with the "sa" account using the a specific username/password option on the Data Link Properties page and the same thing occurs.
  
  At work I have both SQL 7 and SQL 2000 installed on my machine. The system usges NT 2000 and reacts the same as my home machine when accessing SQL Server 2000. The strange thing is that when I create a Data Connection to the SQL Server 7 Northwind database the database designer options are enabled. I  I can use the table designer and add views.  
  
  Have you had any luck?  I'm stuck as well.
  Thanks, TV
  Report abuse
• • Reply

  4 years ago

  by juicemousezero

  juicemousezero

  Usa, United States

  Joined 4 years ago

  Yeah, that's odd behavior... I got mine working eventually. It turned out to be a matter of authentication... and sort of a matter of me being a total moron, too.
  

  
  But anyway, nowadays when I'm making a new site that uses ADO.NET I have to go through all this stuff:
  

  
  grant select on dbo.Table (column1, column2, column3) to [PCNAME\ASPNET]
  

  
  with integrated security to get it to work at all. It's sort of a pain, but at least it works now.

  Report abuse
• • Reply

  5 months ago

  by Manjot Bawa

  Manjot Bawa

  Delhi, India

  Joined 5 months ago

  The new VSTS enables you to convert your imagination into the perfect material images on screen ! Let your mind do the thinking and VSTS will do the rest http://bit.ly/izsu9

  Report abuse
• • Reply

  yesterday

  by daspeac

  damian wood

  alger, Algeria

  Joined 10 days ago

  Hi juicemousezero, the response seems to be too late, but maybe it may help others. if you are still interested, I recommend that you try the mssql fix program, it is a good solution, if you experience any difficulties with database files. This application also converts dbf files. Hope this helps

  Report abuse