Showing posts with label express. Show all posts
Showing posts with label express. Show all posts

Wednesday, March 28, 2012

Is it possible to install SQL Express with SQL standard Edition

Hi,

I have installed SQL standard Edition in my computer for one project. We want to kick off a new project, and intend to use SQL Express, Will anybody advise me whether I can install SQL express when SQL Standard Edition is there? or I need to remove SQL standard Edition first and install SQL express?

Thanks a lot

Haihong

Yes absolutely you can install them side-by-side. You are limited in the number and flavors of SQL Server installs really only by your hardware capabilities. The one caveat is that each beyond the first will have to be named uniquely as you can only have one default instance running. I have SQL Server 2000, SQL Server 2005 Express, and SQL Server 2005 Developer on the same machine and haven't had any problems.|||


Hi,

yes you sure can do this. The new SQL Express instance will have a different port number′, so if you want to connect to this instance you either have to name the port number after the instance name by using the syntax Machinename\InstanceName,Portnumber or start the SQL Browser service which wil redirect the client automatically to the appropiate port number during connection time.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

Monday, March 26, 2012

Is it possible to have sqlcmd connect to local sqlexpress without a parameter?

(SQL Server Express 2005)

sqlcmd will connect to the local SQLExpress server just fine if I give the -S parameter:
SQLCMD -S .\SQLExpress

but is there any way to have it default to that so I can just say:
SQLCMD
?

Thanks,

dwh
You can do something like:
1) Create an Alias thorough Computer Management | SQL Server Configuration Manager | SQL Native Client Configuration
Alias Name: foo
Protocol: Named Pipes
Server: .\SQLExpress

2) Execute SQLCMD using the alias, like SQLCMD /S foo

Peter|||Umm... thanks, but that doesn't really help.

If I still need to say "sqlcmd /s foo", how is that any better than having to say "sqlcmd /s .\SQLExpress"?

Apparently on some machines here at work people are able to just say "sqlcmd" and it will default to the local SQL (Express) Server.

No?

Thanks,

dwh
|||They probably have a default instance installed. If /S is not specified, SQLCMD will try to connect to the dedfault instance. When installing Express, choose Advanced Options and then select "Default Instance". By default the Express setup installs Express and as a named instance called SQLEXPRESS.

To check whether they have a default or named istance, execute sp_helpserver against the server.

Peter

Is it possible to have reporting services without IIS?

Is it possible to have SQL Express and Reporting Services on XP Home and use
reports locally (like Access)?
ThxOn Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
As far as I know, there is not. That said, I'm not sure how SSRS would
react if you somehow tried to tie it to Apache or some other web
server. Sorry that I could not offer further insight.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, Enrique
I guess same applies to Advanced Services
MS, please make this available on XP Home too.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||For development purposes you can install sql2005 dev edition (costs $50 or
comes free with VS2005) and you get all the features.
"AlexS" wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
>
>|||I asked about WinXP Home and SQL Express Advanced / Reporting, which is
available now from MS site for download.
Thanks for a tip - I will check dev edition.
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:9F612C59-BEC7-4854-BF02-C51F8DBFCFD4@.microsoft.com...
> For development purposes you can install sql2005 dev edition (costs $50 or
> comes free with VS2005) and you get all the features.
>
>
> "AlexS" wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>>
>|||On Jun 7, 12:54 pm, "AlexS" <salexru200...@.SPAMrogers.comPLEASE>
wrote:
> Thanks, Enrique
> I guess same applies to Advanced Services
> MS, please make this available on XP Home too.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> > On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> >> Is it possible to have SQL Express and Reporting Services on XP Home and
> >> use
> >> reports locally (like Access)?
> >> Thx
> > As far as I know, there is not. That said, I'm not sure how SSRS would
> > react if you somehow tried to tie it to Apache or some other web
> > server. Sorry that I could not offer further insight.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. SSAS I'm not sure about. Let me know if I can be of
further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It would not work. RS is a asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Is it possible to get MSDE & SQL Server 2005 Express run on the same machine?

Hi guys,

I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication.

Thanks in advance.

Hi,

yes running both instances on the same system is possible.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Yes as said you can run both on same machine without any problem, my machine have both installed on it.

Hemantgiri S. Goswami

|||Thanks guys. I appreciate ur time. :)

Wednesday, March 21, 2012

is it possible to connect to SQL Express without network?

I have notebook, client server application and sql express sp2 on this notebook.

Also, I know domain user login/password,

but I don't know any local user name/password

and I don't know any sql server user name/password.

Domain user is not a local administrator on this notebook.

When notebook connected to the office LAN I am working good with my app-> my sql express as a domain/user.

I'd like to work at home too. I can logon to the system (XP SP2) using domain account when notebook has no network connection. (probably OS caches something)

Is it possible to work with sql express using domain login when no network connection?

PS. old version of this software used MSDE 2000 and it was possible(!).

Thank you.

Yes. SQL Server will still work the same as when you are connected to the office LAN.

Since you log on with your domain credentials (they are cachd on the laptop), the same credentials are used to gain entry to SQL Server.

|||

Arnie Rowland wrote:

Yes. SQL Server will still work the same as when you are connected to the office LAN.

Since you log on with your domain credentials (they are cachd on the laptop), the same credentials are used to gain entry to SQL Server.

Ok, thank you.

I did experiment on 2 workstations.

On one machine ist working good, but on the second machine (no netowrk connection) when I tried to connect to the sql server I have a problem:

SSMS is ocnnecting ok

Application gives me message: cannot generate SSPI context.

What can it be? ...

Thank you

|||

Check these souces:

Error -Cannot generate SSPI context
http://support.microsoft.com/Default.aspx?id=811889
http://support.microsoft.com/kb/827422/en-us
http://support.microsoft.com/kb/843248/en-us
http://support.microsoft.com/kb/269541/en-us
http://support.microsoft.com/kb/267588/en-us
http://support.microsoft.com/kb/814401/en-us
http://support.microsoft.com/kb/818173/en-us

sql

Wednesday, March 7, 2012

IS IT A POSSIBLE SCENARIO WITH EXPRESS EDITION ?

Hi,

I'm new to the express edition and not that expert about SQL Server generally, so I want to get the answer to this qquestion in details - if possible - and as simple as it coule be . Is the following scenario acheivable using MS SQL Server XE:

One server running WindowsXP+MS SQL Server Express Edition, about 10 users with an application to connect to the db in server and work within it.

would this scenario be available using XE?

thanks in advance for replying ,

moemen ahmed

Hi

XE is equlent to MSDE. It is possible to connect to MSDE or XE from diffrent machines and you can also download SQL Server Adnvanced Express edition from Microsoft web sites for free.

Friday, February 24, 2012

Is Express will be launched with Main Product

Hi,

Is SQL Server Express 2008 will be launched with main product (SQL Server 2008) or later ?

Anybody has any idia ?

Express will be released in a later CTP and will ship with SQL Server 2008.

Is Express will be launched with Main Product

Hi,

Is SQL Server Express 2008 will be launched with main product (SQL Server 2008) or later ?

Anybody has any idia ?

Express will be released in a later CTP and will ship with SQL Server 2008.

Monday, February 20, 2012

Is copy of database and log file enough for backup?

Hello,

i would like to copy the SQL Server Express database .mdf and .ldf files for backup. Is this ok?
Autoclose = true and recovery model = simple.

Must i detach the database before copy the 2 files or can i copy the 2 files without detach at any time? When connections are open (also remote connections).
Can i copy at any time even when transactions are active?

I would like to write a copy programm which copies the 2 files every 30 minuutes. Only 30 minutes of work could be lost.

This would be enough for me and i don't have to care for the the BACKUP and RESTORE stuff. In the past i used BACKUP and when i needed this BACKUP it did not run. Returns some error message..

Is copy ok? When is it possible? At any time or must all transactions be comitted? Must all connections (remotes too) be closed? Must the database be detached?

Is this enough to have a valid backup? Backup would be an attach of the .mdf file.

Or must i use the BACKUP and RESTORE stuff? Why?
If so, for what reason is the AUTO CLOSE property there?

Regards,

Markus

And in my opinion attach a database should be enough. ít is the users, the owners, wish to get the data stored in the database.

In the past, as i tried to use RESTORE stuff, i get an error message. From the sql server system point of view this was ok because something of the restore file did not match the STRICT criteria for restore. But i lost the data.

Therefore a attach should do it, to fullfill the wishes of the owner. To show him the data of that .mdf file. Even it this .mdf file does not meet the critierias of the current version. SQL Server should inform the owner of that, and ask if it is allowed to try to converte the file to the current format. If OK, it should do everything to save as much data as possible.

Sorry, if it sounds a bit curious, but i would like a way to do the obvious things without force the owner to take any learning effort.

Read in a blog:
http://www.sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/Default.aspx
This schould not be the case..

Markus

|||

I personaly would use the back up and restore options, this is what they are designed for. You can run these from the Management studio (Express Version) or from a raw query. If you need to schedule it you can either use the normal scheduler that is in windows or use a custom one. For one of my clients I created a windows service that copied the function on the unix cron system but on a windows machine.

The only time that I have used the attach and detach functions is when I need to move a database quickly. I have seen some people use it to install the database when the program is installed, but for this I prefer to code a solution that creates the database from scripts. Doing it this way I know that the structure and data is clean at the time of install.

|||

Thank you Glenn.

But the question was, is copy enough? And under what conditions?

In my opinion, if Sql Server Express should be a common datastore, it should be easy to backup.

Without knowing Sql Server Books online, without knowing what "scripts" are. This is stuff for a few freaks, who likes things like that. But most of the people don't like to read such stuff. Most people hate this stuff.

What is if someone use a Sql Server database (any older version) and want to sell his computer. He copies the .mdf and .ldf file to a cd. He buys a new computer. Installs a new download of Sql Server. Tries to attach the copied files. This should be the only thing he should know. And Sql Server should be the best it can do and not show an error message.

Or what is if someone send's the .mdf and .ldf file via email to another person. Who knows which version of Sql Server he is running`?

What i mean, if Sql Server want to be a datastore of everyone it should meet the needs of everyone. Don*t kow and don't need to know what BOL is or what scripts are. Perform the needs of the owners autmatically and explain him in a few simple sentences.

I think today the normal person is a bit confused.

Best regards,

Markus

|||

When you do use the attach and detach system you do not have to copy the ldf file as this is only the transaction log file, In that should only be open transactions... If you are copying the file to a new location you will need to make sure that al transactions are commited to the database. This is why I prefer to use the backup option as this makes sure that at the time of the backup all of the data is stored. If you do use the attach and detach method there are chances of loosing data.

|||

Hello Glenn,

you wrote:
> The only time that I have used the attach and detach functions is when I need to
> move a database quickly. I have seen some people use it to install the database
> when the program is installed, but for this I prefer to code a solution that creates
> the database from scripts. Doing it this way I know that the structure and data is
> clean at the time of install.

This is what i want to do when my program is installed. Install SQL Server Express with a named instance. Copy the database files and attach them. Because there ist allready data in the database files. What do you think is the risk of that way? Have you ever heard that his fails?


> When you do use the attach and detach system you do not have to copy the ldf
> file as this is only the transaction log file, In that should only be open transactions...

If i use attach and have only the .mdf file, is the .ldf file then new created?


> If you are copying the file to a new location you will need to make sure that al
> transactions are commited to the database.

Is this the case when i use Detach? When does a detach fail?


> This is why I prefer to use the backup option as this makes sure that at the time of
> the backup all of the data is stored. If you do use the attach and detach method
> there are chances of loosing data.

Are there limitations of restore and backup? When will a restore fail? What is of different version ofs sql server, differences betwen the system where the database was backed up and where it is to be restored? Is there allways compatibility or what must the user care for, that the restore will run?

Regards,
Markus

|||

>This is what i want to do when my program is installed. Install SQL Server Express with a named instance. Copy the database files and attach them. Because there ist allready data in the database files. What do you think is the risk of that way? Have you ever heard that his fails?

Well there are certain things that are not stored in the database itself. Logins, for example.

I have had problems doing exactly what you described in SQL 2000, especially when my original database had any users other than dbo.I've had problems with restore as well.

If you are shipping initial data with your product I would recommend that you do it all in code.INFORMATION_SCHEMA is your friend.I've done things using batch scripts and the command line tools.These work but are not flexible enough and don't provide sufficient error detection.

|||

>Well there are certain things that are not stored in the
>database itself. Logins, for example.
>I have had problems doing exactly what you described
>in SQL 2000, especially when my original database had
>any users other than dbo. I've had problems with
>restore as well.

But when you install a seperate named instance for your application? Do you see this problems in this case too?

|||

Yes you do see the same problems, a Named Instance is just like a completly new server install...

Is Conversion from SQL Server Express to Full SQL Server Required?

If I develop my app in SQL Server 2005 Express, and then want to use a hosting service that only offers full SQL Server 2005, do I have to do some kind of conversion to my DB file, and if so, what might that be? (I notice that there are hosting services that provide SQL Server Express...I'd like to know how much work it would be to be able to use other services.)

Any guidance on this would be appreciated.

Thanks!

it is an easy process to upgrade the database... you have two methods that you can use. the first is to use the detatch/attach method... with this you would just detatch the database on you server and then have the hosting company attach it for you. Or you could just use the backup restore method.... This is the way I would go.

|||In case that your hosting company isn′t that friendly to attach the database for you nor will let you know where you can put your backup files on to restore it from that media (like my hosting company isn′t doing for me :-) ) you can use the Database Import Wizard (which works in my case because my hosting company offers port 1433 to the internet for the server) and create a SSIS package to do the job.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Glenn, thanks for the input.

I'm assuming in the scenario you describe that I would upload the mdf and ldf files to "my" directory on the hosted service systems, and then the operations you suggest would be performed from there...is that correct?

|||

Jens, thanks for the input.

In the scenario you describe, would I upload my DB to the hosted service first, and then operate the Database Import Wizard? Or is there another set of file moves involved? (Kind of piecing this together from newbie space :-)

|||No, actually not. As I don′t know which server is hostingn my SQLServer database on the hosting server. Even if I would upload my database I would not know the paths to attach the database. I use the DTS Import / Export wizard over the internet, directly importing the data into the "Internet" database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I would assume you have a "db" folder or "database" folder that you have access to on your hosted web server and, if so, that's where they'll likely go. Talk to your webhost and ask their advice since they'll be the ones working with you on it.|||

Thanks for input. I appreciate that I'll need more detail and coordination with the hoster; this thread has been useful in providing me with orientation on the basic mechanics.

Grazie!