Connecting Without Setting Up A Database Possible?
Nov 28, 2007
Hello everyone, I am fairly new to SQL Server Express and I have a question I was hoping someone could help with. I know this will sound very wacky but please entertain the possibility of such scenario taking place...
Is it possible to connect to an instance of an SQL Server Express 2005, using asp, without having a database created and without configuring anything such as permits or users first ?
The SQL Server Express was installed on a PC that runs a web server as well but nothing else was done, I only have the instance name and I know the SQL Server is configured for local access only.
I was hoping to create a database and begin using it with an asp file that runs SQL commands I can input on a text window, but I can't find connection strings that work without specifying a database name, and also I don't know which user and password to use because it is set to windows authentication.
I thought the code would go something like this:
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Driver={SQL Server};Server=SQLinstance;Address=localhost,port;Database=;Uid=;Pwd="
To top things out the web server is configured to send out a generic error message, so I can't see what the error I'm getting actually is...
I am having serious problems with connecting to SQL Server via ASP.
I have created a User DSN, however when I am asked if I want to use Windows Authentication or SQL Server authentication, I feel I am having problems. If I choose SQLServer authentication, I am asked to enter a username and password which I do (does this need to be a predefined username and password?). I do this and the connection fails with an error saying that the login is not associated with SQLServer. If I choose windows authentication its fine, but when I try to connect via asp using the username and password I login to get into the machine and the DSN name I set up during the DSN setup, the same error comes up. (for windows authentication does the asp code differ from SQL Server authentication?). I really need help here
I have deployed a web server using server 2003 standard edition and have created a functional web site... Now I want to create a SQL data base and make a DB connection using ASP.NET using Dreamweaver as my HTML editor... This is where I get totally lost and confused...I have SQL 2005 instralled on my web server and have gone through the help files and some of the tutes but am still spinning my wheels... Can anyone please help this wanna be MSDN...
I need help configuring my sql server and then connecting to it via dreamweaver and then creating a data base for data collection from my web site...
Hi I initially installed VS 2008 with no problems. It installed SQL EXPRESS. I then installed SQL Developer edition. Still No problem with connecting or using the database. I picked up problems setting up Reporting services. I could not configure the server. I then decided to unistall SQL and re-install the developer edition. Now, I cannot even connect to the server.
Hi there! My provider does not yet support SQL Server 2005, they are still on SQL Server 2000. I put together a very basic login page, but it is crashing everytime I access it because of this problem, and sadly I am not advanced enough as yet to know how to remedy it! Can you help? Here is the error page, some of it; - Any ideas gratefully received! Russ.
Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
whenenver i run cold fusion, it automatically gets my tables out of the master database instead of the new one i have created. i've added a user that has a default to the new database instead of the master, but i need to know how to use that new user correctly, and what i will need to do once i start adding more databases so that cold fusion will go to the appropriate database and not to the master.
In the VB 2005 Express, I can get the SqlConnection and ConnectionString of a Database "shcDB" in the Object Explorer of SQL Server Management Studio Express (SSMSE) by the following set of code: ///--CallshcSpAdoNetVB2005.vb--////
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Public Class Form1
Public Sub InsertNewFriend()
Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;"
Dim connection As SqlConnection = New SqlConnection(connectionString)
Try
connection.Open()
Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)
command.CommandType = CommandType.StoredProcedure ....................................... etc. /////////////////////////////////////////////////////// If the Database "shcDB" and the Stored Procedure "sp_inertNewRecord" are in the Database Explorer of VB 2005 Express, I plan to use "Data Source=local" in the following code statements to get the SqlConnection and ConnectionString: ......................... ........................
Dim connectionString As String = "Data Source=local;Initial Catalog=shcDB;Integrated Security=SSPI;"
Dim connection As SqlConnection = New SqlConnection(connectionString)
Try
connection.Open()
Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)
command.CommandType = CommandType.StoredProcedure ........................ etc.
Is the "Data Source=local" statement right for this case? If not, what is the right code statement for my case?
I have been using MySQL as the back end of my .Net 2.0 applications for a while using a custom membership provider without any problems.Having now switched to a new webhost which supports both MySQL and MS SQL Server 2005 and also creating a new site thought I should set up the new site to use MS SQL..... I am having trouble however setting up the SQL server to act as the membership provider. Following the advice on here I tried using aspnet_regsql.exe... Firstly, when trying to get the list of databasses on the remote server I get the following error: Failed to query a list of database names from the SQL Server. Invalid object name 'Sysdatabases' If I then just type in the name of my database and go through to the end I get the following error:Exception:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated. I can connect to my MS SQL server remotely without any problem using the likes of MS SQL Server Management Studio Express. Is there any other way I can setup the databases needed for user and roles access control or is the usage of MS SQL much more complicated than what MySQL was?
. The BPA recommend that the model database setting for the items below be set to on. I can accomplish this task through the query analyzer and run the set command. (Set ANSI_NULLS on). The response is positive but when I re-run the report the setting are back off.
I'm in the process of trying to set up my first SQL Server database and things aren't going as per the book! (surprise, surprise).
The 'Identity Specification' option during Table creation, is 'greyed out' and won't let me set (Is Identity) to 'Yes' or anything else for that matter.
I guess that there's a simple answer to this one, but as a newbie to SQL Server ( and VB 2005) I'm curently at a loss.
Hi all,I come up with a problem aleady discussed in some posts especially in the post http://forums.asp.net/t/1235761.aspx. but I got in not finally solved.The main problem is connecting to a database twice which causes errors. So I think this might be the right place to ask my questions. Here ist the problem in short:I'm using VWD on XP-Professional with SQL-Server Express and Reporting Services Express. All with Windwos Integrated Security and User Instance (SQLExpress). In my web-application I had for all Datasources the connect string:Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|mydatabase.mdf;Integrated Security=True;User Instance=True This works fine so far. I also have Reports designed with the Report designer using the same connection string. I can preview the reports and I deployd thre reports successfully. I want to call these report using a report viewer web control.Now the problem:when I call the remote remote report from my web-application, the database cannot be opened because an other process is using the database (see post mentioned above). It seems that this is a problem with attaching the database twice: from the sql-server and from the report-server.So I used now a new connection string without "attaching" the database (in vwd and in report designer):Data Source=.SQLExpress;Initial Catalog=C:inetpubwwwrootmyappAPP_DATAmydatabase;Integrated Security=True Now everything works...but ... only on my machine. On the production machine this does not work. I wonder anyway, why its working on my machine, because I never "attach" the database (there is no connection string with AttachDbFilename and I have not opend the developer and have not opened the sql management studio).On the production machine the concurrent (SQL-Server and Report-Server) connection to database does not work with either connection strings, no matter if i attach the database with sql server manager or not).This all drives me crazy for days now. All I want is to use SQL-server and Reporting- Services with its nice features and not repairing my tools. I thought I have a standard Installation, nothing special, but the standard obviously makes problems.Here finally my question:Does this environment ( web-application with remote reports) with Express edition cause normally no problems?Can I "attach" a database only once? How should I connect with my web application that uses the sql-server connections and also the report-server-connections (attaching twice does not work).What connection strings to use and when (AttachDbFilename or Initial Catalog).Are these problems specific to the Express Editions? I thank you in advance for any help Dieter
I'm having trouble changing data in my database. It is actually a VB cuestion, but you see, i just finished lesson 9 of the begginers Visual Basic 2005 video series and in my last run i can't save the data i've changed into the database. no errors are shown, it just does't change the values. i know for a fact that the code is well written and there is no problem with the configuration of buttons and such, because i folowed the steps 50 times so I believe it must be a SQL configuration problem. does anybony have any insight on what the problem might be. THX malcolm
we have a database that only serves Select requests (no OLTP) for our very high traffic websites. what are the benefits of turning on read-only setting for the database if there are no transactions occuring in the database? does sql server put locks on tables for SELECT statements?
There has been a lot of discussion about moving single databases or devices in same server. Can someone suggest the most simplest method to set up a identical server with all the logins, permissions and password etc?
Building a new server with sp_help_revdatabase and dumps/loads is relatively easy but moving the master is confusing to me. I should run the new server and databases for a little testing period (with diffrent server name, of course) and then go live by dropping the old and by adding the new. I remember someone said that this would be as easy as copying master.dat to new machine (when servers are identical), any experience or other suggestions?
Does anyone know how to set a database priority? I have a SQL Server that contains multipule databases. One of the databases is very high priority. I need to make sure that no matter what is running on the server that this database's processes take priority and nothing slows it down.
Is there any practical downside to setting ANSI_NULLS and QUOTED_IDENTIFIER to ON at the database level? Almost all devs will simply leave these default settings at the top of a stored proc script anyway.
I want to query my databases to find out if Auto Shrink is set. I know the status column in sysdatabases holds this value as a bit setting but I don't know how can I check this value using a query.
Hi,When I create a new database from Enterprise Manager (right click ondatabases > New Database) I noticed that I am not prompted to create apassword or user name. Can I take it then that all databases under thesame local group will have the same password and user name?I have tied to access the newly created database using the samepassword and username but haven't had any luck.Thanks
I am new to Sql server and hope that someone in here might be able to help me out with a little advice on how to go about how to achive the following.
My boss wants me to set up a copy of one of our production databases, the copy is supposed to be used for running questions against thru businessobjects. There will be aprox 10 simultanious users, the original and the copy must never be further apart in time then 15 min. The database is today about 25 gigs and to make it even more complicated the copy must be available at all time during business hours (8-17). The solution is also supposed not to influence the production databases perfommance to much (really low impact to the performance is a key issue).
The options I have thought of is: 1. Use mirroring and then take a snapshot of the mirror for the users to connect to. 2. Replicate only the data that is needed. 3. Log shipping in a combination with the online restore option in sql 2005 server. 4. Log shipping and then take a snapshot of the copy for the users to connect to.
I have also thought about if the need for current data is that high it might even be better to let them run their questions directly against the production db instead since there will not be so many simultanious users.
Any of you guys that have any ideas, all tips will be very appreciated!
Hey All, I'm very new to ASP.NET and have recently begun using the databinding functionality. So far, all I've had to do is drag and drop the various controls and then use the data source wizard to set up an appropriate query. However, now I've got a bit of a different need. In the VB codebehind, i need to be able to ask whether something is true in the database, and then if it is, carry out functions. So, for example, what I need to do is: if (SQLStatement "Select charttype FROM charts WHERE datasource = " & dropdownlist1.selecteditem.tostring()) Then 'do whatever end if Trouble is, I don't know how I would go about binding the data so that I could access it in this way. Any guidance would be very much appreciated. Thanks,J Rankin
Hi, I'm trying to create an SQL script that creates a new login account for each of our databases. The one remaining problem with the sql is it could not set the current database using a variable(e.g. USE @dbasename). I tried looking for another way of setting the current database but could not find one.
Is there any other way of setting the current database other than the USE command?
I currently have a server with the collation set to SQL_Latin1_General_CP1_CI_AS.
However, some of the databases within the server are set to Latin1_General_BIN, probably because they were restored from another server some time ago. Also, even within the databases that have Latin1_General_BIN, some of the columns are set to SQL_Latin1_General_CP1_CI_AS, very confusing to say the least.
What i would like to do is change the database collation settings for these databases to match the server setting. I would also like to change all of the tables within these databases to have the columns also set to the server collation settings.
I'm looking for the steps that i would need to take to make sure i don't mess anything up as these databases have there own sets of views and sp's that run each day.
I learned how to make SQL database BACKUPs through Maintenance Plans in SQL server 2005 in my own computer. So my question is: When I finally would be deploying my ( asp.net 2.0) web site in a distant real server, how could I set a Maintenance Plan there ?
I need help setting up my primary keys for a database table. Suppose I have two tables, as listed below. The first one isa table of students and the course they are enrolled in. The second table is a table of test scores. Never mind that this could be designed better. Please just using my design as an example, I need help.
First table - Student Table Student Id Student Course Building1 Joe Math101 Primus Hall2 Jake Engl103 Indigo Hall3 Mary Art107 Money Hall So my question is the following. On my second table below, can I just haveone Key as the Primary key? Just like in the first table. I will have a primary key named "TestId" If so, how do I set up my table so that the values in the "TestId"table will be automatically generated upon inserting into the Testscore table.
I've mapped a sqlserver machine within vs2005, but when I attempt to set the database connection, I dont see place to stick the port number (even in the advanced area)... it continues to fail when I test the connection.. I can telnet into the machine on the sql server port, so I know its open to me... Also - when I publish this to an IIS server, what is the syntax for placing the connection and port number in web.config? I've tried various settings, cant get it to work. <appSettings><add key="con" value="Server=12.123.123.123;PORT=1234;UID=*****;PWD=*****;database=mydb" /></appSettings>
Our company has several SQL Server 7 databases. One of them has now on two occassions, set itself to 'Single User' mode. I am completely baffled as to what can be causing it.
There's no jobs set up to do it. There's no stored procedures programmed to do it. The SQL Server Log shows that a DBCC CHECKDB ran at 18:00:37.73 and that users attempted to and couldn't log in from 18:01:01.95 onwards. There is a maintenance plan set to run every two hours that does a backup, integrity checks, so it fired the CHECKDB.
I have a several questions with regards to setting up a server to cater for multi tenant database.
I have a requirement to host 100 isolated databases for the purpose of multi user environment where each user has it's own database. This is due to security restrictions that why it was requested to be such.
1. What I'm recommending is to setup servers with 256GB of RAM to host multiple databases. Are there servers which can accomodate 256GB? Is this optimal with regards to performance? Or should I break it down to smaller servers with less RAM?
2. Is there a way to determine the CPU requirements for the DB server, taking for example we have 20 databases per DB instance? Are there any best practices / calculators available?
3. Additionally, data from the 100 DB's needs to be consolidated into 1 central repository for Analytics purposes. What I'm looking at is to utilize SQL Server transaction replication. Is there any drawback with this approach? Are there any other approach we could use to easily replicate data across 100 database back to 1 central repository?
I am new to sql server and i would like to set up a multimedia database (includes photos) using sql server (regardless of the version). How can i achieve that?
