Installed SQLServer Express.....now What?
Jan 13, 2007
Hi
I've succesfully installed Visual C# and I've made a couple of example projects. I now want to try and create a database and see if I can make a C# application that talks to it.
So I've installed SQL Server Express. I was hoping I could open it up and get started with creating tables etc. Instead, my Start menu shows:
Microsoft SQL Server 2005
>>>Configuration Tools
>>>>>>SQL Server Configuration Manager
>>>>>>SQL Server Error and Usage Reporting
>>>>>>SQL Server Surface Area Configuration
Where do I go now? Is there some configuring to do before I can start making tables and storing data? Or, have I misunderstood what SQL Server is about?
Thanks
Rich
View 1 Replies
ADVERTISEMENT
Nov 19, 2007
I am working to develop an application using dotnet framework 2.0 that requires loading tab delimited text file (generated on each user action) in to table of SQL Express database. I am thinking to use SSIS library (Managed DTS) to call my SSIS package from within my application to load this data on each user transaction. This should be noted that I am not hosting my packages in to SQL Express.
Microsoft allows redistribution of SQL Express for free. Do I need any SQL Server or any other type of license for using SSIS library from my application?
-Faisal
View 5 Replies
View Related
Jan 26, 2006
Hi Friends,
I have a question. At my home computer i downloaded and installed VWD. As usual it also installed Sqlexpress as part of the installation(i checked the option). Later on i downloaded Management studio separately so i am fine with my home computer as every thing is free.
But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not understing where do i get the Management studio? Is it some thing i could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
Please advise. Thanks -L
View 3 Replies
View Related
Jul 20, 2005
Hi,Does I need to install the mssql client binaries to use ODBC toconnect to a mssql database ?TYIArjp
View 2 Replies
View Related
Jul 7, 2006
Hi Fellows,
I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here .
My site is : Windows XP Professional SP2
Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network.
I ran setup from : server directory and also from tools directory.
In my programes menu I can only see Configuration Toolsunder which there are three options :
1) SQL Server Configuration Tool
2) SQL Server Surface Configuration Tool and
3) SQL Server Error and Usage Reporting
View 11 Replies
View Related
Sep 20, 2006
Hi experts;
I have a problem with unicode character 0x2300
I created this table
create table testunicode (Bez nchar(128))
Insert Data
insert into testunicode (Bez)values('’')
with 2 Unicode characters
= 0x2300
’ = 0x2122
Selecting the data
select Bez from testunicode
I see
"?’"
’ = 0x2122 is ok but instead of 0x2300 there is 0x3f
When I modify the insert statement like that ( 8960 = 0x2300 )
insert into testunicode (Bez)values(NCHAR(8960)+'’')
and select again voila i see
"’"
Does anyone have an idea?
Thanks
View 1 Replies
View Related
Jan 12, 2006
Hi,
I have many sql 2000 DTS packages that I support from my development workstation running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc.
I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product. The 2005 DB instance is running on a seperate server.
So, I have dev edition of sql 2000 and 2005 client tools (including BI Dev studio etc) on my workstation.
I have recently had to make changes to a 2000 DTS package and used my 2000 enterprise manager to do so. No Problem- saved and tested fine on my workstation.
But when I try and release it to another server, or open the package using enterprise manager from another machine that does not have sql 2005 installed - I get an error message 'Unspecified error'. This I've seen before when trying to open packages created in v2000 , using v7 or where the service packs are different between machines.
Digging around my workstation and comparing some of the DLLs I know to be required to distribute DTS packages (from RDIST.txt) it seems that some of the SQL 2000 dll files have been updated by my 2005 installation.
E.g
DTSFFILE.DLL on my machine is 2000.85.1054.0 whilst on any 'clean' 2000 machine is at version v2000.80.760.0
Surely it cant be right that SQL 2005 has newer versions of components for SQL 2000 than is available with the latest SP for the actual product! Especially considering that the installation of 2005 does not even allow you to edit 2000 DTS packages through the management studio without a 'special' download' of the feature pack,(whihc by the way does not work very well either)
So am I to conclude that you can not run side by side installations of SQL 2000 and 2005 on a single machine and expect 2000 to run as it did previously !!!
View 2 Replies
View Related
Apr 18, 2008
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.
I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?
The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.
Thanks!!
View 1 Replies
View Related
Jun 14, 2006
I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000.
Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection.
If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is:
server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS"
DB name: name of db instance
port: 1433(default)
user and pass.
My attempts so far results in
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."
and
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
View 1 Replies
View Related
Apr 18, 2007
Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?
Thanks.
View 7 Replies
View Related
May 18, 2006
Hi-
I had previously had VS2005 Beta installed from my MSDN discs. When it expired, I uninstalled it and downloaded VWD Express to install. VWD installed fine, but the SQL Server Express will not install. The VWD install package doesn't give me any feedback, just says it failed. I tried dowloading and installing SQL Express separately, and it tells me that I have to uninstall all components from other versions. I have done that, but still wont install. If I use the uninstall utility on the website, it tells me it can't find any components, and all of the components listed in the manual uninstall instructions are missing, so I can't find anything further to uninstall. (FYI: I'm running XP Pro SP2).
I'm wondering if a registry setting or something didn't get updated on uninstall. I see a registry folder for "Microsoft SQL Server" but I do not know if this could be getting in the way.
Any help would be appreciated.
-Moz
View 3 Replies
View Related
Dec 29, 2006
my system meets the requirements and I have installed .net framework 2.0,
why can't i run sql express?
I tried running it from command prompt but nothing happens?
View 1 Replies
View Related
Jul 24, 2006
This may be a stupid question, but I've installed SQL Express and I don't know what to do next. I went to my program files/Microsft SQL... and the only folder present is a configuration folder.
Next I went to my control panel/admin tools/ODBC and succussfully created a user data source. (With the help of the forum!)
Obviously, I've never used SQL before, but I've read a couple of books and other stuff online, and I want to teach myself. So I decided to install this. Basically, I'm looking for answers on how to access the database. I know it's installed, it's in the Add/Remove programs list. I just don't know how to connect/access it.
Sorry for the dumb question.
Stacey
View 6 Replies
View Related
May 22, 2007
Hi All,
I had Visual web express and SQL 2005 express installed. Then I uninstalled SQL 2005 for a period of time. In that time, I installed Office 2007 with Business Contact Manager which uses a SQL 2005 database for it's contact DB. I beleive it's a SQL express 2005 version, I'm not sure. Anyway, now I install SQL 2005 express again. I install it as the default instance. The problem is, it's no longer COMPUTERSQLEXPRESS, it's now COMPUTERMSSQLSERVER.
I've found in the Machine.Config where the provider is located for ASP configuration and I changed it from .SQLEXPRESS to nothing and that did the trick, the ASP.Net Web configuration tool works fine now.
The problem is now Visual Web Express doesn't think SQL Express 2005 is installed. If I try to create a database, I get a warning to install SQL Express. I can't find the setting where I can tell VWD that SQL is installed and it's called MSSQLSERVER instead of SQLEXPRESS.
Thanks
Tony
View 2 Replies
View Related
Sep 4, 2007
using windows xp with visual studio
once installed, how can you tell wh ichis installed:
Microsoft SQL Server 2005 Express Edition (SQLEXPR32.EXE)
Microsoft SQL Server 2005 Express Edition with Advanced Services (SQLEXPR_ADV.exe)
I have checked all the obvious.
Please advise.
Thanks,
Bob
View 1 Replies
View Related
Apr 5, 2007
Hi guys,
I am a Systems Engineer and was sent on a job to a site that has a newly created SBS 2003 R2 Premium box which was OEM pre-installed from Dell. The SBS install was evidently finished off by the I.T. guys at the site. Now along comes some software house to install their propritery application. During this install process, the software guy was unable to find an instance of SQL running and installs SQL 2005 Express and the Express Studio management console. He installs his application and before he leaves says to the I.T. guys "Oh and by the way, there is a 4GB limit per database on SQL Express. You will have to change that to workgroup edition before the data grows too big. Have a nice day byeee!!!".
The I.T. guys go "Huh? Lets call James." So now I have to get this database off the SQL Express instance and onto a workgroup instance. I understand about detaching a database and re-attaching it. No prob there. What is confusing me is when I look at the default instance which should be a Workgroup instance, all I see is an Express instance.
What I am planning to do is rip out all the SQL 2005 stuff, leaving behind only Sharepoint, SBSmonitoring and WSUS stuff. The, using the SBS Premium cd's, install SQL 2005 again and updating the service packs for it again. Then mount the databases under it and get the software guys back in to reconfigure their application if need be.
Thing is, I have no idea how to sort it all out other than "Add remove programs" in control panel and remove the SQL 2005 stuff. What scares me however, is the thought of also removing the Sharepoint, WSUS and SBSMonitoring databases too.
Can someone help me with a procedure for sorting it out? How can I tell what I should uninstall and what I shouldn't? How do I tell if workgroup is already there and why did express steal the default instance?
Cheers
James
View 1 Replies
View Related
Jul 17, 2006
Hi everyone,
I believe I have installed SQL server 2005 (SQLServer2005_SSMSEE.msi) and I can run "Mircosoft SQL server Management Studio Express"
I can see the "Connect to Database Engine dialog", however I am unable to connect to a server (I know I need to create a server or instance but don't know how ;-( ):
Server Type: Database Engine
Server name:
Authenitication: Window Authentication
User Name: myIDmyID
Password:
Now, how do I create a server name (instance?)? Do I need to download other software to create an instance so I can try the SQL Server locally?
Please help ,I am lost ;-(
View 1 Replies
View Related
Jul 12, 2007
so ... now what do I do?
When I launch the app I am asked for server type: DATABASE ENGINE or SQL SERVER COMPACT EDITION.
the server name is blank. Im stuck here. some one please help?
View 7 Replies
View Related
Jan 26, 2007
I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:
The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.
That's the very short version. I've got a ton of hours reading help groups, MSDN, trying everything.
I have posted the error log file below. Thanks in advance.
=== Verbose logging started: 1/25/2007 21:01:41 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:6b4bf5519a6c349936f69599setup.exe ===
MSI (c) (2C:64) [21:01:41:265]: Resetting cached policy values
MSI (c) (2C:64) [21:01:41:265]: Machine policy value 'Debug' is 0
MSI (c) (2C:64) [21:01:41:265]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (2C:64) [21:01:41:265]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (2C:64) [21:01:41:265]: Grabbed execution mutex.
MSI (c) (2C:64) [21:01:41:281]: Cloaking enabled.
MSI (c) (2C:64) [21:01:41:281]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (2C:64) [21:01:41:281]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (98:90) [21:01:41:296]: Grabbed execution mutex.
MSI (s) (98:E4) [21:01:41:296]: Resetting cached policy values
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'Debug' is 0
MSI (s) (98:E4) [21:01:41:296]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (98:E4) [21:01:41:296]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (98:E4) [21:01:41:296]: User policy value 'DisableMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Looking for sourcelist for product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Adding {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Now checking product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media is enabled for product.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Source with value name '1' is blank
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing net source list.
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing media source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 2203 2: 3: -2147287037
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Processing URL source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1402 2: UNKNOWNURL 3: 2
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Failed to resolve source
MSI (s) (98:E4) [21:01:41:312]: MainEngineThread is returning 1612
MSI (c) (2C:64) [21:01:41:312]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (2C:64) [21:01:41:312]: MainEngineThread is returning 1612
=== Verbose logging stopped: 1/25/2007 21:01:41 ===
View 4 Replies
View Related
Apr 23, 2006
setup support flie error.
View 7 Replies
View Related
Oct 8, 2006
I am attempting to install SQL Express 2005 on a laptop that already has MS Sql Server installed.
I downloaded the SQLEXPR_TOOLKIT.EXE from Microsoft's website and let it go through its installation routine accepting all the default answers.
When I open SQL Server Management Studio Express, I can only connect to the SQL 2000 instance. I have issued the 'SELECT @@VERSION' command, and When I try to connect to the instance COMPUTERNAMESQLEXPRESS, the following error message is displayed:
Cannot connect to YOUR-F8A010A9D0SQLEXPRESS.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure my 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) (Microsoft SQL Server)
When I go to remove SQL Express 2005 using the add/remove programs, there is a check box that says
"Remove SQL Server 2005 instance components"
and in the box underneath where it lists all the instances it says: "No instances have been installed"
How do I create an instance for SQL Server 2005?
Thank you
Susan
View 1 Replies
View Related
Mar 21, 2006
I created a mdf file but couldnt for the life of me install it into SQL Sever Express [and when I say install i mean attach]. When I used SQL Server Ent, I had no issues. The only warning I got was that my mdf file was used by another process when I tried to attach with VS 2005 [ which is correct because ent had it]. I think mdf files are pretty touchy. Does anyone have any good articles on best practices? It seems you cant have a db with the same name as your attachment [ which would make sense] or have mdf files in the Data directory of your SQL Server instance you are trying to attach to. You will get the unc share error if you do. I think I need to start using user Instances but I could be wrong. You cant use them in ent but maybe i will solve my issue with attaching db files to express. I noticed that by default express doesnt install in mix auth mode and there might be some issues with access. How does everyone else normally install their mdf files for quick deployment [ say you want to deploy your db with your app so that users can quickly get started] ?
View 1 Replies
View Related
Apr 30, 2007
I have downloaded Sql-Server Express Edition along with Visual Studio and Microsoft.Net software. However I cannot see it in my start programs what have I done incorrectly? JT.
View 3 Replies
View Related
Nov 7, 2006
I'm new to SQL Express and from the SQL Express DOWNLOAD page you need to install .NET Framework 2 then install SQL Express. After installing .NET Framework 2.0 I then attempt to install SQL Express and I get a message that SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework or SQL Server 2005. I used the Visual Studio removal tool and it took out .NET Framwork. I re-installed this and did a reboot and get the SAME ISSUE! CAN ANYONE GET ME OUT OF THIS MS loop nightmare.
Thanks! Jeff
View 5 Replies
View Related
Jul 26, 2006
I am aware that instances of both can exist on the same machine.
But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000
Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again.
I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005.
When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back.
In the event log, there is an entry
The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: (SpnRegister) : Error 1355.
I have down all the usual things like uninstalling SQL Server Express 2005 (using control panel and msiexec /x {GUID}), patching the registry etc etc
The result is always the same.
The Sony Media Manager is not important and I probably won't use it but it's annoying the hell out of me - I've always claimed, over a good few years, that there was no computer problem that I couldn't finally solve, but presently this has got me beat and I feel undone!!!!!!! :-)
regards
Stuart
www.mckears.com
View 3 Replies
View Related
Jan 7, 2008
We are needing to script to find out if our servers have a full version of SQL Server installed or if it is just SQL Express that is used by one of our backup software vendors. How can we do this? Currently, we are having to go into each server and look at the SQL console. Anything that someone can suggest would be greatly appreciated as we have hundreds of servers to go through.
Thanks much in advance.
Cathy
View 6 Replies
View Related
Nov 24, 2006
A couple of weeks ago I installed SQL Express on a system that also has VS 2005, Front Page and other applications. Now the Front Page application can no longer connect to the web server and I keep getting a message:
Server error: Error 2 opening registry key "SOFTWAREMicrosoftShared ToolsWeb Server ExtensionsPortsPort 80".
Has anyone else seen this error? Any suggestions on resolving this.
I did try a reinstall of Front Page and the error is still there.
John
View 3 Replies
View Related
Feb 21, 2007
Hi All! I'm a newbie to SQL & have a question about Reporting Services. I have already installed SQL Express & now want to install Reporting Services. Is there a way to install just this feature or do I need to do a complete re-install? Thanks!
View 5 Replies
View Related
May 16, 2007
I installed SQL Server Express trail for 3 times each with new instance. Now I came to know that I need to have a default instance. I un-installed the SQL Server Express and tried to install it again. It still says I have installed instances and if I select default instance the option buttons are un-checked and disabled. I tried to delete all the folders related to the SQL Server installationa dn tried but still I see the same thing. Please help me in istalling the default instance.
Thank you.
View 1 Replies
View Related
Nov 2, 2006
We have serveral app groups that have installed SQL 2005 Express, but each group have installed different components. How can I determine, specifically if the following components were previously installed.
ADDLOCAL=SQL_Engine
ADDLOCAL=SQL_FullText
ADDLOCAL=RS_Server
And if not installed re-install with the missing component??
Thanks
Tony Z
View 1 Replies
View Related
Apr 11, 2008
Hi,
A simple question. I installed successfully Visual Studio 2008 Standard edition on my VISTA Ultimate 32bits machine. During install process, I also checked SQL Server Express 2005 item.
Which version of SQL Server Express 2005 did it install? Are we talking about SP2? If so, can I install without problem a more complete SP2 package using following links
SQL Server 2005 Express Edition with Advanced Services SP2 http://go.microsoft.com/fwlink/?LinkId=65109
Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?LinkId=65111
without screwing the now existing SQL Server Express setup VS2008 installed?
Thanks in advance,
StΓ©phane
View 14 Replies
View Related
Jun 21, 2007
All --
Please help.
Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine?
That is-- can one connect directly to an MDF in the same way and Access MDB file can be used?
If no, then is there any way around this?
If yes, then are there any limitations?
Please advise.
Thank you.
-- Mark Kamoski
View 1 Replies
View Related
Jan 8, 2006
Hi, i have sql server 2005 standard installed on my machine. I want to work on express edition and learn about it but on the installation its gets stuck because a higher version is installed. If the express version is free why cant have both versions installed on my machine. Thank you.
View 7 Replies
View Related
