I got 2 questions to ask:
1. I choose Windows and SQL authentication during setup. Will this have any impact on my connection string in Dot net?
2. If I want to host my db on my computer, what other protocols do I need to enable? Currently I got shared memory on.
This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.
Thanks
I'm troubleshooting a performance issue , Looking at Profiler - for the given statement, I'm getting the following figures , why would there be such a disparity between the figures. ? How can I go about finding out why there is such difference?
SQL:Stmt Completed:CPU = 31, Reads = 129 , Duration = 32
SQL:Batch Completed: CPU = 2531, Reads = 6087 , Duration = 2593
Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
I'm new to using SQL server and have a few setup questions.
I'm setting up a database for the company I work for. Should I setup a different database for each division in our company (e.g. accounting, project management, estimating, etc.), or should I use just one database? It seems like it would be easier to use one database so I only have to use one connection, but is this ideal? I want all the info from the different divisions to be used together, but at this point I'm confused as to how to connect different databases together, if I were to go this way.
Thanks for any input or ideas!
Hi
We have a small Ethernet LAN running SBS 2003 R2. I have installed SQL Server 2005 that came with that release on the server. I did not specify a named instance.
1) What is the name of the default instance?
2) When I go to a client computer I cannot see the SQL server instance.
For example on my PC I have VS2005. If I go to Server Explorer, all I see is the local copy of SQL Server 2005 Express I have installed on my PC. I see nothing for the server. Does the server need configuring within SQL Server to allow this. Do I need to change permisions on the folders where the SQL Server 2005 files are stored.
In short, what basic steps do I need to follow to get acces to SQL Server on my server from a client.
3) If I want to create a new named instance, do I have to do Run the whole setup again? There appears to be no managemnt tool for instances of SQL server.
Thanks
Steve
All:
I am writing an Internet/Extranet based (ASP.Net 2.0) web application that uses SQL server 2005 as the database. I am using forms authentication on my web application. I am also storing the connection string to SQL server in my web config file. The conn string is encrypted using DPAPI with entropy. I currently have created a SQL login account on my SQL server for use by the web application. This is the user ID I am using in my conn string. The reason for this is because all persons using the application will NOT have a windows login.
Here is my question: The login I created currently has defaulted to the "dbo" role and therefore has "dbo" rights to the database. I want to setup up this login account so that all it can do is execute stored procedures. I dont want this SQL login to be able to do anything else. In my application I am using stored procedures for ALL data access functions, via a data access layer in my application. Can someone guide me step by step as to how to setup this type of access for this SQL login.
Thanks,
Blue.
Hello
I have a windows application that connects to a SQLExpress database hosted on a shared server. The client machines will run an interface software and interact with the info within SQL The SQL database isn't huge (50 megs) and all of the info is text. The interface application isn't too complex either, it was designed using VB.net05. I have a few setup questions:
1 - Is it best to use Windows or SQL authentiaction? Currently I am using Windows authentication and I have a user group setup on the DNS that is setup as a user for the SQL database. That has worked so far, but I've only had a few users logged in at one time so far. My plan was to add all DNS accounts that will use the software to the DNS user group, thus giving them access to the SQL database.
2 - I know this gets asked a TON, but I am interested in knowing how many users I should be able to support using the current setup. I have the one user acount setup for the DNS user group. The SQL table is not huge and it is all reading and writing text. The server is running Windows Server 03 and is a couple years old (not sure of exact specs).
Thanks for any help, I am still learning my way around SQL and it's great to have such a vast amount of support for the product.
Happy New Year!
Paul
Typically small companies or small projects which use SQL Server / IIS / File Shares / .NET solutions deploy these apps on a single server many times using just one IP address and the NETBIOS name of the server for both IIS / SQL. Many times there is no use of DNS and even when there is everything is mapped to the server/netbios name.
As environments grow and there is a requirement to create an n-tier server setup possible due to new security requirements, extention of the intranet to the internet, or to scale out an application you may need to split IIS / SQL into different servers. The question then becomes how do you do this without affecting existing services and you want to have minimal down time without having to change all connection information within deployed apps until you have time to review the changes carefully.
First let me begin with how to move IIS away from SQL and then I'll discuss the reverse.
The best way I've found to control the move of IIS sites is by assigning each site it's own ip address / dns host record and adding the ip address to the server network card and IIS site. Now each time you need to move 1 or more sites you can simply replicate the site to another server and change the dns ip pointer to the new pointer. If you have existing sites which were not setup in this fashion you can also move them to a new server, create a site with name of the old netbios machine name, and redirect the default web site to this new site.
Now you successfully isolated SQL Server from IIS/.NET apps you can take your time and correct the apps to use the new dns entry in connection strings instead of using the netbios name of the machine. Once you have corrected the app you can turn off any redirection.
Now let's assume you have the opposite scenario where you started off with a small server and your SQL database server now requires a server with more memory / more processors and you want to keep IIS / FileShares were they are and want to move SQL Databases to a new server. As I mentioned above a good way to do this is by setting up each database with it's own dns entry a very effective redirection mechanism. However you are may be inheriting a system which does not employ this mechanism and again uses the default netbios machine name, furthermore this may get more complicated because there may be multiple instances of SQL Server running on different port numbers.
You could use SQL Aliases on the clients to redirect connections to the newly created instances but this would require changing every pc and IIS server and it would be cumbursome to manage. It would have been nice if microsoft provided a way to redirect from the server just like IIS does but they did not. A product which will help you setup a server based redirection of ports 1433/1434 and/or any other ports is called porttunnel by steelbytes.com. Once you've installed the redirecting service on the server all new requests on port the ports selected will be redirected to the new server which I recommend be redirected to their own dns entries and this will buy the applications developer time to change their applications.
I would like to hear any comments or experiences with this that any of you may have had or if anyone has found a better solution. I'm in no way associated with the product / or company mentioned above just found it to be a good solution.
Best Regards,
Valter Borges
Hi,
We implemented SSIS packages which read data from an operational system at our customers site. This system is one of the primairy systems used in the organisation and is vital to the organisation. In what situation ever the operational system shouldn't be affected in its operation by the SSIS packages. Unfortunately the following problems occur:
1. Sometimes a SSIS packages waits infinetly. We tried the 'with (nolock)' and 'with (readuncommitted)'' statement in the source query but without succes. The package just keeps on waiting and the SSIS proces won't finish. It seems the package is just sleeping without resuming.
2. On a specific day the operational system got disturbed and end-users couldn't proceed working because the application hang. According to the system administrators our SSIS package caused a lock on a table in the operational system. Which we find is a kind of strange because we use a simple 'select ... from with (nolock)' query.
We prefer not reading directly from the operational system so we adviced to bring in a mirror read-only database where the SSIS packages can read from. Unfortunately the mirror system will not be up and running within three months from now.
Anybody can advise me what to do because I am running out of options.
Thanks,
Marc
I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.
BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Apr 03 19:36:56 2007
(As you can see, there is nothing in the file)
Any ideas what could be wrong?
Thanks
Pedro
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error Number : 29513
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Sun Mar 04 15:27:03 2007
List of log files:
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core(Patched).log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Datastore.xml
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_.NET Framework 2.0.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Support.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SCC.log
I have a few questions about SQL express.
Will SQL express make my workstation (regular PC on network) act as a server? Or does it just allow VB express / Web Developer Express to write code that will work on an actual My SQL server?
The goal is to make a simple DB that will then be used on a website on a live server which has My SQL on it. I don't need SQL express on that server also do I? MY knowledge about SQL is next to null.
Thanks
What is the user limit for SQL Express?
Is there a free way to convert Access files and import them into SQL Express?
Is there any way to take databases offline without have to detach them?
Hello,
i have some questions about the SQL Express Edition.
I read here, that the maximum of one Database is 4GB.
When i create a Webapplication, and i implements, the MembershipProvider, RoleProvider and the ProfilProvider, how many Users can i add to one Database ?
I think that i will have 60 - 100 Field Entrys for Profile of one Person.
Please can everybody help me with this Question?
I need this Information, why i dont know that i make my Webapplication with SQL Express Editon, or with Mysql.
Thanks for your Answers
Best Regards
Siggi
SQL Express 2005 Install
Question 1) If you leave the hide advance options checked, which of these 3 options does it choose on the Service Account Screen (I believe it is Network Service).
Local Service
Network Service
Local System
Question 2) If you uncheck the hide advance opitions, so you can access the Service Account Screen, which is the better option, local service or local system for a stand alone computer the the database is only accessed by a program runnin gon that computer
Question 3) I have installed SQL Express 2005 on 3 machines, two of them gave me a default instance of SQLExpress, the third of MSSQLExpress. We need the same instance name on all machines, or we would have to change the connection string on the program each time.
Why is the 3rd machine doing that?
Thanks,
Bob
Hello - I'm about to rebuild my website on a nice new windows 2k3 server. I was previously using SQL server 7 but I'd like to use the 2005 edition.
Here's my first question - is the Express edition 2005 good enough to use on my live web server? Are there limits on the amount of connections at any one time?
My second question is this - what's the best way to connect to SQL Server 2005 Express?
At the moment I would use something like:
Server=.SQLEXPRESS;Integrated Security=True;Database=myDB
And then I would set up a COMPUTERNAMEASPNET account under SQL Server 2005 Express.
Is that an ok way to connect??
Any ideas?
Thanks.
I'm a long time user of SQL Server 2000 but no knowledge of 2005 Express.
View 5 Replies View RelatedNote: Please refer to my previous message to see the current VS2005 C# code I am using to create my database.
This database will be used for short term operations. In otherwords, a user will create the database, generate a lot of data that will be created using:
SqlBulkCopy bcp;
Then, there will be 'activity'... updates, queries, deletes, etc for a few days and then the user will at a minimum remove all of the data and at some future point in time, will recreate the data and do the process all over.
In otherwords, I am not concerned about backups or transaction logging or recovery or any of these 'normal' issues of using a SQL database.
That said, how do I use SMO to keep the LDF limited in size and as small as possible (assuming I can't turn of the tranaction log to begin with).
2nd question is...I read soething about being able to log ONLY the exection of a Bulk Copy operation. How do I specify that? This is my SQLBulkCopy code.
SqlBulkCopy bcp;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = m_dbFiles.conMain;
bcp = new SqlBulkCopy(sqlCmd.Connection);
bcp.DestinationTableName = "tblMyTable";
bcp.WriteToServer(datatable);
Returning "completed" when status = 1 and "not completed when status = 0
View 3 Replies View Related
So I am fairly new to Express and I have installed it on my development machine; much tio my chagrin it is quite difficult to import data into SQLEXPRESS. I have a 'sa' account setup and I have created a new database and table within that database, however, when I try to import data into that table by setting up a link server to excel I am having some major issues!
I ran this code first to create the linked server...
DECLARE @RC int
DECLARE @server nvarchar(128)
DECLARE @srvproduct nvarchar(128)
DECLARE @provider nvarchar(128)
DECLARE @datasrc nvarchar(4000)
DECLARE @location nvarchar(4000)
DECLARE @provstr nvarchar(4000)
DECLARE @catalog nvarchar(128)
-- Set parameter values
SET @server = 'XLTEST_SP'
SET @srvproduct = 'Excel'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @datasrc = 'c:Anchor_Hocking blactionlist.xls'
SET @provstr = 'Excel 11.0'
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider, @datasrc, @location, @provstr, @catalog
Next I try to run any of the statement below and I get the errors pasted below...
SELECT * FROM Anchor_Hocking...Sheet1$
EXECUTE SP_TABLES_EX 'Anchor_Hocking'
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=c:Anchor_Hocking blactionlist.xls;User ID=sa;Password=sa;Extended Properties=Excel 8.0')...Sheet1$
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Anchor_Hocking" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Anchor_Hocking" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Anchor_Hocking".
The file is not open. I have granted full access rights to all users....I am really frustrated!
Also, how can I get SSIS on this machine with SQLEXPRESS?
-Brian
1. The title of this post says it all. My app will have a very small footprint to down load. I don't want to user to have to download 50 + MB just to try my little $15 app:-) So
QUESTION 1 - Will SQL Express be in the Vista bits? If so which versions?
2. Once SQLExpress is installed by whatever means, are there rules about how the instance is used? I have no problems playing well with others so I would be more than happy to create my DB in .SQLExpress.
QUESTION 2 - Are there any rules governing who can play in the Express instance? How should dtabases should be named to avoid collisions with the other kids?
3. I'd love to be able to work in in ClickOnce / user never has to have admin password environment.
QUESTION 3 - Besides UAC are there any constraints on writing to a properly installed Express instance that would get in the way of a pure user application from using the basic instance.
4. Right now - because I can't read directions and still don't understand the smoke and mirrors in VS 2005 when it comes to dealing with databases - I have DDL in my program that allows me to create my database from scratch. Not sure that this is the right way to go.
QUESTION 4. What is the best way for an user software to create its database in an instance of SQL Express.
5. SQL Express is yet another thingie that will run in the background that the typical user won't understand and wont' give a hoot about.
QUESTION 5. Can I / should I programmatically worry about whether the service is up and running? If so how do I launch it.
I know this is a lot for a single post, but it all sort of hangs together.
Regard,
Al Christoph
I can choose synchronization direction for articles: a) Bidirectional b) one way
1) Is that possible somehow to replicate the schema only of an article but no synchronization / zero direction :-)/
2) Same question about columns, I should replicate schema only for few columns, but without data synch. These columns are freely updateable at anywhere (publisher and subscribers), but the data changes shouldn't be replicated.
Thanks for the answers in advance
Hi all, i have standard edition of sql server, on a server hat doesnt have sql server standard would i be able to connect to it using my connection string. Or does the server has to have standard edition too. Is this same for express edition, and if possible to do this whats the difference between express connection string from standard edition thanks
View 3 Replies View RelatedI will be teaching a web scripting course, and I would like to switch from using MS Access to MS SQL as a database. Please forgive my ignorance, as have much to learn about SQL Express. We have installed SQL Express on a web server (windows box).
Question1:
is SQL like MS Access, in that the SQL Express software should be installed locally on the users machine. The user will create databases and tables locally, then upload the resulting database(s) to the appropriate folder on the web server along with web scripting files?
-------- OR ---------
is MS SQL like MySQL, where the db is installed on the remote server, and user accounts are created within the database with appropriate priv.'s. The user logs in to the db application remotely to create tables within a given database.
When I install SQL Express I get a setup failure for the following:
MSXML6-Setup Failed
SQLServer Database Services-Setup Failed
I had SQL Express installed before and I remember having a little trouble uninstalling it at the time. My machine is a Dell Inspiron with 2GB RAM and a 60GB hard drive with 50GB available.
Here are the logs:
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Feb 29 19:46:55 2008
Machine : ELYKMAIN
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ELYKMAIN_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : ELYKMAIN
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ELYKMAIN_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : ELYKMAIN
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ELYKMAIN_SqlWriter_1.log
--------------------------------------------------------------------------------
=== Verbose logging started: 2/29/2008 19:48:24 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (14:50) [19:48:24:014]: Resetting cached policy values
MSI (c) (14:50) [19:48:24:014]: Machine policy value 'Debug' is 0
MSI (c) (14:50) [19:48:24:014]: ******* RunEngine:
******* Product: {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
******* Action:
******* CommandLine: **********
MSI (c) (14:50) [19:48:24:014]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (14:50) [19:48:24:014]: Grabbed execution mutex.
MSI (c) (14:50) [19:48:24:030]: Cloaking enabled.
MSI (c) (14:50) [19:48:24:030]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (14:50) [19:48:24:030]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A0:FC) [19:48:24:030]: Grabbed execution mutex.
MSI (s) (A0:F4) [19:48:24:030]: Resetting cached policy values
MSI (s) (A0:F4) [19:48:24:030]: Machine policy value 'Debug' is 0
MSI (s) (A0:F4) [19:48:24:030]: ******* RunEngine:
******* Product: {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
******* Action:
******* CommandLine: **********
MSI (s) (A0:F4) [19:48:24:030]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (A0:F4) [19:48:24:030]: MainEngineThread is returning 1605
MSI (c) (14:50) [19:48:24:030]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (14:50) [19:48:24:030]: MainEngineThread is returning 1605
=== Verbose logging stopped: 2/29/2008 19:48:24 ===
Any help would be appreciated.
The just released SP1 version of SQL Server Express has a file name of sqlexpr.exe. The previous setup file was named sqlexpr32.exe. Why would Microsoft change the file name?
Anyway, the file name change obviously breaks the file name that is coded in the bootstrapper package.xml file. Also, the link address will need to change (I suppose Microsoft couldn't just put a new version at the same link with the same file name so that everything would just keep working?)
Is there a revised package.xml file we can use? If not, do we use the same publickey?
Are the necessary changes documented anywhere?
Thanks
Russ Stevens
I downloaded Visual Studio Express CD Image named "vcs.iso". I did not do the installation because I'm not the admin.
Does it comes with SQL Express and the SQL Server Management Studio Express?
Another question is, Is it possible to move the database (with the data as well) from SQL Express to SQL Server?
I have a pc for developing application using all the express edition and There is a Server with SQL Server edition.
Its 2 different pc so will there be a problem?
Thanks,
Max
I've installed and unistalled SQL Server 2000 and MSDE on my computeras I needed it (my machine is a development machine).I've tested SQL Server B2 and then uninstalled it, now when I try toinstall SQL Server Express B3 I can't get the client side tools toinstall (the command lines).The server is apperantly working, but I can't log into it because Idon't get any of the clients.How do I fix this?
View 2 Replies View Related
Hi, I just installed the Express version locally and then tried to simply connect to the
Northwind database from a .aspx web page. I get the following:
Error reading the database. 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Do I have to do anything for setup?
Thanks, Eric
Im a beginner in ASP.NET and SQL. Please tell me how to run and paste a few tags on "SQLCMD T-SQL execution command line utility" (90ToolsBinn). Its SQL Express 2005. I cant paste a tag of an ASP.NET beginners site http://www.asp.net/GuidedTour/default.aspx). I cant set up a data base without doing it.
When attempting to run this installer (SQLCMD T-SQL execution command line utility), I get the DOS screen but not the 1> command prompt. If I leave the screen alone, the DOD command window closes after about 5 seconds.
"C:Program FilesMicrosoft SQL Server90ToolsinnSQLCMD" -S "machine-nameSqlExpress"
If I retry the prompt, same thing happens. Attempts to Paste the script are unsuccessful, and the DOS command screen closes on it's own.
Tank you very much,
nuno vieira
One of my customers is trying to setup SQL Server 2005 Express SP1 on his Windows XP Home SP2 machine.
Setup failed with the following in the Summary.txt file:
-------
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Mon Dec 04 23:59:22 2006
D86VH461 : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Mon Dec 04 23:59:23 2006
---------
What is this D86VH461 error code? I seached the Internet and could not find any information on it.
Thanks,
Herbert
I have a Windows Mobile aplication that uses merge replication to synchronize between sql compact and full sql Enterprise edition and It works great. Instantiating the SqlCeReplication object setting it's properties and calling Synchronize on it is pretty simple assuming everything is setup properly at the publisher.
For the life of me I can't figure out how to do this on the desktop (Programatically setup a subscription and create a database using objects in the System.Replication Namespace and hopefully call Synchronize on it).
Someone please point me in the right direction.
Thanks,
Patrick
Hi,
I have install Microsoft Visual C# Express Editon 2005 from MSDN site. I have follow this step
.
Uninstall beta versions
Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0.
2.
Download and install
Download and install Visual C# 2005 Express Edition!!
Download
Note: Having network issues or need to burn a CD for offline installation?
Follow the manual installation instructions.
3.
Register
Why
register? You€™ll need to get your registration key. Additionally,
you€™ll get a lot of free stuff including royalty-free images from
Corbis, online training from Microsoft Learning, E-books from Microsoft
Press and more. Learn more about registration benefits.
before that i also insatl IIS from windows service pack 2
My problem starting when I'm trying to enable connection to the database with setup the ODBC my step
1.Start>>Control Panel>>Administrative Tools>>Data Sources(ODBC)
2.System DSN>>Add
3.Select>>SQL Server>>Finish
4.Put Name:>>>Choose Server:>>>Next
5.Select>>>With SQL Server authenticationusing a ID and password enter by user>>>Connect to SQL Server>>>put Login ID:sa>>>Next
6. Test Data Source
7.Error
Connection failed:
SQL State:'01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect( )).
Connection faild:
SQL State:'08001'
SQL Server Error: 7
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
Please help me step by step. I'm using C# to build application that can pullout data from card using chip like smartcard or chip based card. The data then save to database in SQL. Using Macromedia I'm build a website that can publish the data to web site. My mission to set up my CPU as Server using SQL Server. I'm build all my project in the same CPU with the server.
tq.