.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Connestion string create any database server

Posted By: sagar pardeshi     Posted Date: March 17, 2010    Points: 2   Category :Sql Server
This links important to how to create connection string to any data base sever.

View Complete Post

More Related Resource Links

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

How to create a view in my database from a table in another server/database

Is there a way to create a view in my database referencing a table in another server/database if I have the connection information.  I know how to do it in Oracle, simply create a database link, but have never done so in sqlserver.

Windows 7 CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 26

Hi I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and  SQL Server 2008 R2.  I get CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) when I try to create a new database.  Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions.  Run as administrator (vista fix) does not work. I have admin privaleges on my machine.  There are no other accounts.    What do I need to do to update privaleges? Thanks and have a nice day.    

Cannot Create Database Diagrams - SQL Server 2008 Management Studio

I cannot create a database diagram with my client-side SQL Server Management Studio.  I can do this if I am on the actual db server itself.  Please help.

please help me to create database in sql server 2008

hi,    i am new to asp.net. i like to learn asp.net and c#. when i try to connect to sql server, it asks server name. i don't know server name and it asks database name also. how to create database and where can i access like phpmyadmin. in phpmyadmin i can create database and tables. i am new to this. please help me.thanks.  

Create view that amins to tables of another database on the same sql server instance

Hi to everybody, I found a situation ever met before. I develop on Dynamics NAV 5.01 and I have developed a method to be able to see some particular tables of an external database. In substance it deals with a property of tables of Dynamics NAV. When I create a table in NAV, I can create it in 3 different ways: table common to all the companies table  for company or table linked to a view.    This last case is mine, on the same db of NAV I have created a view with some fields, I have created in NAV a table linked with equal fields and types. Until here all normal.    The view, however, aims to another database that doesn't center anything with NAV but that it is on the same intance of SQL server.    The consumer that accesses NAV is a consumer type database SQL Server and has the permitted db_public and db_datareader on both the database. Then he can read the views on the db of nav both on the db of the other database.    When it tries to enter from the console of sql server, with the consumer database, all it works, if I do it by NAV, it show me an error "The server principal "username" is not able to access the database "some_database_name" under the current security context. (Microsoft SQL Server, Error: 916) "    If I add on the database NAV to the consumer, the role db_owner,

SQL Server 2K5 - C# Create database - Catch error



    using (SqlConnection sqlConnection = new SqlConnection("Data Source=" + session["DWSERVER"] + ";Initial Catalog=master;Integrated Security=SSPI;"))


     ServerConnection svrConnection = new ServerConnection(sqlConnection);

     Server server = new Server(svrConnection);

     string script = File.ReadAllText(session["INSTALLLOCATION"] + @"Sources\DW.sql");

     script = script.Replace("[SSASSERVER]", session["SSASSERVER"]);

     script = script.Replace("[DWSERVER]", session["DWSERVER"]);

     script = script.Replace("[DBSERVER]", session["DBSERVER"]);

     script = script.Replace(&q

Create database permision denied in database ' master' (MS SQL SERVER, ERROR 262


Cn not do anything with my sql server, everything i trt to do i get this message, user does not have permision, etc, ,

I am running windows Vista Business, SQL SERVER 2005

so what going on here


Cannot create database diagrams for sqlexpress .mdf file in Visual studio server explorer



I've look around the forums but I can't get the solution for my problem. I've installed Visual studio 2010 with sqlexpress edition. Then I have renamed my computer. After renaming my computer I've deleted the directory C:\Users\uporabnik\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. After restart, I have started VS2010, open Server explorer and I've added the connection to a new database. I've been able to add new tabels, bu when I've tried to add a diagram, it didn't work. In properties window od the database I saw, the the database owner was oldComputerName\username not newComputerName\userName. In sql server management studio I've reanmed the user oldComputerName\userName to newComputerName\userName. After attaching the database it worked fine.

I've returned to Visual studio 2010. When creating new database, the owner of new database is oldComputerName\userName. The next tip was renaming the  SQLServerMSSQLUser$ComputerName$SQLEXPRESS(and other names with sql...) in Local Users and gorups in Mange My computer. After restarting the compter I've got the same result. When creating new .mdf file in server explorer of visual studio, the database owner is oldComputerName\userName.<

create an infopath form that receive and submit data to sql server database in the same form



i want to create an infopath form that can receive the data out of the slq server database and edit the data in the database and then submit it.

here is what i did so far.

i created a data connection to a sql server database to SUBMIT the data.

also i created a data connection to the same sql server database to RECEIVE the data.

when i open the form the user and the user's details are already filled in the form, now i need to let the user edit the data in the fields or add a new data in a field and then the form need to be submitted to a temporary database to be checked first by an approver and after approval the form must be submitted to the real sql server database.

i tought about that the approver just need to click a button and the data will be submitted to the the real database.

both the temporary and the real database has the same tables and fields.

i just need to know how to edit and submit the data to the temporary later to the real database



Server is completely empty and I can't create a normal database


I use Microsoft SQL Server Management Studio Express on Windows 7.

Don't ask me how, but when I was erasing a database I no longer desired, I erased the 'Database' folder on the server.

Pitiful I know, but I am only learning how to use databases this year... and I'm not even learning it on MSSQL.

Every time I try to connect to a new instance, it is created without any folder to place databases and running a script that used to restore a database I have returns an error saying that the token 'RESTORE' is incorrect. This didn't happen before.

I've tried uninstalling SQL Server and SQL SMSE and re-installing. No matter how much I try to erase every residue of past installations, the new installation always recovers the state of the previous one, showing exactly the same server structure and database name.

How do I remake the entire server?

P.S. I'm curious as to why this information is stored in my computer, information that I am unaware of. Is the Server a part of Windows itself? Why can't I control the information the system stores and simply erase any evidence of a previous server so I can create a new one?

create sql server database based on the dataset c#


Hi all,

I am reading xml file using dataset.readxml() method. . . after this i want to send this data to the database. I want c# code to create a database in sql sever and push watever data in the dataset to that created database.... i am dealing with many xml documents... some could be of same format.. lets say... if 2 docs of same format exists... then it shud not create new database or new tables.. it shud push the data to the suitable format...as i am a newbie its a bit confusing for me... i dont even have any idea on how to proceed with this... please reply if you know the answer for any part of the requirement... any help is very much appreciated..




Error when configuring Report Server Database - Wizard is trying to create Database on a non existen


I'm trying to setup SSRS using the Reporting Services Configuration Manager.  Everything seems to be working except the database creation.  When I click on the Database (3rd option down) then Change Database I run through the wizard.  Put in proper SA credentials.  Accept the defaults clicking next through and when it gets to running the script to create the data base I get the Error I pasted below.  We do not have a G drive so I went into SSMS and changed the Default Database settings to point to the F drive (where our other DBs reside) - I got that tip off of this forum but it didn't fix my issue. Any ideas what to try next?  Do I need to stop and restart a service or something?  Thanks for any help you guys can offer.

System.Data.SqlClient.SqlException: Directory lookup for the file "G:\mssql\data\ReportServer.mdf" failed with the operating system error 3(The system cannot find the path specified.).

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateO

need to get value of Port ,Database Name and Database Server while creating "Create New Web Applica



1> i need to get the value of PORT ,Database Name  and Database Server while creating "Create    New Web Application" using Central Admin under "Application Management "  on "OK" button.

2> how to get these value on OK button click, i need to retrive these value and wirte it into text file.

3> Any other idea to get these filed value ?


thanks in advance



how many logins we can create on sql server database

how many logins we can create on sql server database.please tell  me maximum number of logins in sql server.2000,2005 and 2008.

sql server 2008 r2 install does not create database engine, also mmc creates error "Failed to create


I am loading sql server 2008 r2 developer edition into Windows Vista Home Basic. Product loads correctly with no error messages; except will not create database engine. And will not create integration services. When I try to open MMC, I will get error "MMC could not initialize the snap-in. Product may not have been installed correctly."

I understand this is a known issue for SQL Server 2008 RD installing on Windows Vista? What is the workaround or fix? Hot fixes available for this issue from support.microsoft.com do not install on my Windows Vista Home Basic machine.


Failed to create new database in SQL Server Management Studio Express



I don't know why I can't create a new database in SQL Server Management Studio Express.



This is the reason:


CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

Server Name: Ning-PC\SQLEXPRESS
Error Number: 262
Severity: 14
State: 1
Line Number: 1

Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndW

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend