The tag has no wiki summary.

learn more… | top users | synonyms

-8
votes
0answers
26 views

SQL SERVER DATABASE ACCESS USING V6 [closed]

I am using VB6.I am new to SQL Server. I have an application where more than 1 user can access the SQL Server database from their workstations. I have few Q's regarding this: I want detailed PC ...
0
votes
0answers
14 views

SQL Server Express Application Deployment Via CD

Our company has an ancient home-grown Win-32 application which uses a SQL Server Express db. We have a salesperson at a remote office who has no reliable internet and I need a way to package this app ...
-2
votes
2answers
134 views

Connect SSMS to SQL Engine on VMWARE machine [closed]

This my first question so forgive me if i did anything wrong and tell me about it please. I have a VM on VMWare Workstation 9, it's windows 7 and i installed SQL Server Express on it. And i am trying ...
0
votes
3answers
77 views

How to connect to ms sql express?

I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
1
vote
1answer
177 views

My php site cannot connect to SQL Database - SqlExpress2012

Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2. Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted ...
0
votes
0answers
562 views

Creating database from Entity Framework and Code First create database error

This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out. I'm running on MSSQL 2008 Express, EF5 and MVC4 My web.config file looks a bit like ...
0
votes
1answer
433 views

cannot connect to sql server express from sql server standard

... like my title says... I cannot connect to my instance on sql server express from sql server standard... I have tried disabling firing wall and checked sqlbrowser is started but for some reason I ...
0
votes
1answer
58 views

SQL server 2008 are prevented form being installed on Windows 7 - error message “access is denied ”

I have recently installed Windows 7 enterprise . When I try to Install Microsoft SQL server 2008 EXPRESS edition , I get an error message : "Access is denied" just right after the installation process ...
0
votes
0answers
623 views

Automate Sql Server 2008 R2 Express install - silently and pre-configured

I want to create a .MSI installation of my app. One of the things that should be installed it's the SQL Server 2008 R2 Express, but i want it to be installed silently, pre-configured for all client ...
1
vote
1answer
503 views

Why is SQL maxing out at 50% of CPU on my EC2 c1.medium instance?

I'm new to AWS, so I think this might be a really simple question: I'm using an EC2 t1.micro instance as my SQL DB server for some small-scale analysis that I'm doing (Windows, SQL Express 2008). It ...
0
votes
1answer
45 views

SQL Express 2008 uninstall not complete

How do I get rid of SQL Express 2008 after it's been uninstalled. It's all over my file system and all over the registry on 2008 R2 server sp1.
1
vote
1answer
124 views

Unable to connect to remote MS SQL Server 2008 Express SP3 instance by name

I am trying to connect to a remote MS SQL Server 2008 SP3 x86 Instance using it's name. At the first glance all seems to work well (e.g. it is possible to connect to the server locally and ...
1
vote
1answer
41 views

SQL Server Express Default Protocols Set On Installation

Are named pipes and TCP/IP disabled by default, when SQL Server Express 2008 is installed? I am trying to figure out if these two protocols being disabled was an act of installation or subsequent ...
-1
votes
1answer
33 views

MSSQL service fails to come up on vm restart

We have a MS SQL 2008 R2 express installation on a VM. If the entire VM node reboots then the SQL service fails to come up. Restarting the VM in isolation results in running service. We have put the ...
0
votes
1answer
291 views

Clarrification for SQL Server Express 2008 R2 on CPU limit (CPU based on core based)

I'm aware that SQL Server Express 2008 is having few limitations on the database size and the CPU utilization. In MSDN documentation it was mentioned on the express edition would use only one CPU. I ...
0
votes
1answer
148 views

SQL express 08 R2 running on Windows datacenter server 08 optimization

I am running SQL server express R2 on Win Server Data Center 08 (basically Ec2 micro instance). My total allowed memory is 613 MB. When I launched the instance for the first time my total consumed ...
0
votes
2answers
75 views

Remote connections allowed, firewall off, SSMS still can't find SQL Express

My remote server running 08 R2 can connect to it's SQLExpress instance via SSMS. db Properties has 'Permit remote connections ticked'. Firewall off doesn't help. Another thread here shows 'sqlcmd -e ...
0
votes
3answers
799 views

Connect to remote SQL Server instance using Windows Authentication

How can I connect to a remote instance of SQL Server (on my VPS) from my local machine using Windows Authentication? By default, if I try to connect using this method, the username is my computer ...
1
vote
1answer
394 views

Trouble installing SQL Server Management Studio Express

Using VirtualBox I am running 64 bit versions of ... Windows Server 2008 R2 SQL Server 2008 R2 Express SharePoint Foundation I want to install SQL Server Management Studio Express, but I get this ...
0
votes
1answer
59 views

SqlServer doesn't allow other users to login from other computers

I have a server running MS SQL Server 2008 Express. Windows Authentication is used to authenticate the accounts to determine what they can and cannot access. I have no problems accessing the server ...
2
votes
2answers
46 views

SQL2008 and SQL2008r2Express on same server

I'm going to add a SQL2008r2Express instance to a Win2003 server where a SQL2008 instance already exists. The new (express) instance will have another name, of course. That is to use the 10GB free ...
3
votes
1answer
41 views

Can an Instance of SQL Server Express 2008 R2 be used as a Master Server?

For multi-server administration, can an instance of SQL Server Express 2008 R2 be used as a SQL Server Agent Master Server?
1
vote
2answers
393 views

SQL Server Express - Move by Copying Data Folder?

We are moving our SQL Server to new hardware. Initially we were going to do this simply via backup and restore, but noticed we'd have to recreate all the logins. We don't want to do that :) ...
0
votes
1answer
441 views

Sharepoint Foundation License Costs [duplicate]

Possible Duplicate: Can you help me with my software licensing question? This question keeps getting asked however I could never get a straight answer. So I'm asking it clearer: If I have ...
0
votes
1answer
73 views

How to configure SSL on an instance of SQL Server to allow dedicated users to remotely access it?

I have configured the instance of SQL Server to allow dedicated users to access it remotely. Connection string Data Source = 192.168.1.2,1433\sqlexpress;etc... has been tested and works. However, I ...
0
votes
0answers
1k views

SQL Connection String to access localhost\SQLEXPRESS

I've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a webpage in Visual Studio to, basically, SELECT * from a table in the SQLEXPRESS, but I ...
0
votes
1answer
283 views

Infrastructure setup question about Exchange 2010 and SQL 2008

How would you set up this scenario concerning a network of 22 users? I have 2 servers for actual hardware with raid and 12gb and 16gb of ram. Both are Server 2008 R2 standard. Both servers are ...
0
votes
5answers
195 views

200 Sites using 200 SQL Express DBs or 1 SQL Standard?

Let's say you have an Amazon EC2 Server. What should use less resources: 200 Websites.... each using an individual SQL Express DB (200 in total, 1 per site) or all sites using 1 SQL Standard ...
0
votes
1answer
49 views

moving data from sql server express 2008 to mssqlserver version 2000

I know I'm going the wrong way but is there a way to move a database from a SQLEXPRESS 2008 server to an MSSQLServer version 2000?
0
votes
2answers
469 views

SQL Server 2008R2 Express: which is the users limit in a real case scenario?

I know that sql server express has not a user limit, and every application has a different way to load/stress the server. But let's take "a typical accounting software", where users input some ...
0
votes
2answers
539 views

SQL 2008 R2 express: Server Cannot open database requested in login 'xx'. Login fails. Login failed for user 'NT AUTHORITY\SYSTEM'

I have SQL Server 2000 installed on the server. I installed SQL Server 2008 R2 express edition as required for new application. The application runs on the same server which is Windows Server 2003 ...
0
votes
1answer
343 views

Search Server 2010 Express with full SQL Server 2008

By default, standalone installation mode of Search Server 2010 Express automatically installs SQL Server 2008 Express. Is it possible to use standalone mode with full SQL Server 2008, not Express? Or ...
2
votes
1answer
610 views

Installing MS SQL Server 2008 R2 side by side with MS SQL 2008 R2 Express edition

I have to install full version of MS SQL 2008 R2 (it's Web edition) side by side with MS SQL 2008 Express (for a short period, before migrating all db's to full version). I guess that it can be ...
1
vote
1answer
114 views

Is SQL 2008 Express R2 really free like 2005 Express is?

About to download it, keeps talking about "evaluation" and "evaluating SQL 2008 R2" and want to be sure it doesn't expire after 60 days or something.
2
votes
3answers
1k views

SQL Server 2005 Express: date of mdf file doesn't change, ldf file get huge

Sorry if the question has been answered or is asked in a wrong way - I am developer, no sys- or database admin. Problem: An SQL Server 2005 Express mdf file (size 370 MB) didn't change it's file date ...
1
vote
1answer
593 views

Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke

we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the ...
0
votes
1answer
324 views

Installing SQL server service, account to use

I'm in the following situation(With SQL 2008 Express): It says "Microsoft recommends that you use a separate account for each SQL Server service." Okay. This is my local machine I'll be developing ...
1
vote
4answers
655 views

Cannot get SQL Server 2008 Express R2 to get through firewall

Try as I might I cannot get remote access to my install of SQL Server. I know the firewall (Windows Server 2008) is the problem, since if I drop the firewall I can connect fine. I have the port open ...
1
vote
1answer
47 views

Any gotchas to installing SQL Express 2008 after SQL Server 2008 on same machine?

Are there any particular issues to watch out for? This is for my development machine so I will be debugging against both SQL Express 2008 and SQL Server 2008. Is the same SSMS used to connect to ...
0
votes
1answer
8k views

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
1
vote
2answers
915 views

Sql Server 2005 Replication to Sql Server 2008 R2 Express

Is it possible for a Sql Server 2008 R2 Express instance to subscribe to a publication on Sql Server 2005? This is for Merge Replication. Update: Please note the Publisher is Sql 2005 and the ...
0
votes
2answers
297 views

SQL Server 2008 Express, need to copy a table from one server to another automatically

We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other ...
0
votes
2answers
432 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
4answers
137 views

Using SQL Express creatively

The company I work for has an old sql server based legacy system, it's been around for about 7 years old with a 13gb database. There are two servers, web + sql. If we were to partition the database on ...
0
votes
1answer
233 views

Does SQL Server Express 2008 R2 eliminate the need to install MS SQL Server 2008 Express then SP1?

To install SQL Server 2008 plus SP1 on Win 7 machines, you have the following options: 1) install the deployment (runtime only - no management tools) version with SP1 built in 2) install the pre-SP1 ...
-3
votes
1answer
1k views

SQL Server 2008 R2 Express accepts only local connections? [closed]

Coming from question SQL Server 2008 connection tagged under sql-server-2008-express Chris S wrote in SQL Server 2008 R2 vs. SQL Server 2008 R2 Express: "The biggest different I see others ...
1
vote
3answers
2k views

SQL Server 2008 connection

I'm trying to connect to my SQL Server on my VPS but i can't get this to work. I have enabled the TCP/IP protocol on SQL. I also have the SQL Server and SQL Browser service running as a network ...
3
votes
4answers
5k views

SQL Server 2008 R2 vs. SQL Server 2008 R2 Express

What differences exist between the pay and free version of MSSQL2008R2? Microsoft SQL Server 2008 R2 http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx and Microsoft SQL Server 2008 R2 Express ...
1
vote
1answer
207 views

SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue

I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk... I am running in the strange ...
0
votes
1answer
470 views

SQL service log on account

I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day ...