Difference

Are SQL Server Express & SQL Server 2005 one & the same thing? Or is the former a part of the latter? Actually when I was downloading Visual Web Developer 2005 Express, I was given the option to download Microsoft SQL Server 2005 Express Edition as well; so I am getting confused between SQL Server Express & SQL Server 2005.

I installed SQL Server 2005 in my WinXP Pro m/c. from the Microsoft website (after re-installing WinXP Pro since XP became corrupt). Earlier I used to login to Management Studio Express using my m/c. name followed by a \ followed by SQLEXPRESS as the server name. So if my m/c. name is MyPC, then I used to login to Management Studio Express using MyPC\SQLEXPRESS as the server name but now when I try to login to Management Studio Express using the above server name i.e. MyPC\SQLEXPRESS, then an error gets thrown saying

Cannot connect to MyPC\SQLEXPRESS.

Now how do I find out what's the server name so that I can login to create & manage databases in Management Studio Express?

Please note that after re-installing WinXP Pro, my m/c. name has remained the same; I didn't change it.

Thanks,

Arpan

>> Are SQL Server Express & SQL Server 2005 one & the same thing?

No. Express edition refers to the free version released by Microsoft with some limitations. Where the other editions have many other features.

The major limitations of express edition are :

* Lack of enterprise features support
* Limited to one CPU
* One GB memory limit for the buffer pool
* Databases have a 4 GB maximum size

>> Cannot connect to MyPC\SQLEXPRESS.

Please use the Browse option instead of typing the server name in Management studio to find the server.

|||

Thanks, Bool, for highlighting the differences.

As far as not being able to connect to SQL Server 2005 is concerned, when I click the option <Browse for more...>, under the Local Servers tab, no servers get listed & under the Network Servers tab, 3 servers do get listed under Database Engine but none of them belong to me! Why isn't my local server not getting listed under the Local Servers tab?

What do I do next? Please help me resolve this issue.

I guess I should have mentioned this in the first thread of this post itself. It would have saved me some time. Anyway, better late than never!

Thanks once again,

Regards,

Arpan

|||

These articles will point you in the right direction to connect.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

This article will help point out the version differences:

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

And this may be helpful (if you don't have it...)

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx

|||

>> under the Local Servers tab, no servers get listed

>> What do I do next? Please help me resolve this issue.

Then I think it means that the local server does not exist or has been stopped. Try to restart the server (refer some books on how to do it), or worst case, just try to reinstall the express edition database engine again.

did debugging with SP3 ever get fixed for Visual Studio.NET?

When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
from Visual Studio - single stepping into the stored procedure.
I spent a day trying to fix it maybe 8 months ago - and gave up.
Are there any tech notes that actually work to restore the ability to debug when
SQL Server is on the same machine as Visual Studio?
If not, can I fix the problem by un-installing SQL Server and then installing
the SP2 version? I'm unclear if the database files would have any problems with
this - or have any problems when moving SP2 databases to my SP3 production
boxes?
--
Thanks in advance, Les CaudleWe can get it to single step through the procedure, but not set a breakpoint.
Was it ever possible to breakpoint? I note the documentation states it will
not "Break", but we took that to mean one could not break the execution and
re-start.
Cheers
Happy Harry
"Les Caudle" wrote:
> When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
> from Visual Studio - single stepping into the stored procedure.
> I spent a day trying to fix it maybe 8 months ago - and gave up.
> Are there any tech notes that actually work to restore the ability to debug when
> SQL Server is on the same machine as Visual Studio?
> If not, can I fix the problem by un-installing SQL Server and then installing
> the SP2 version? I'm unclear if the database files would have any problems with
> this - or have any problems when moving SP2 databases to my SP3 production
> boxes?
> --
> Thanks in advance, Les Caudle
>

devenv.exe hangs up with alomost 100% cpu usage

For some reason my visual studio with SSIS project hangs up with almost 100% cpu usage sometimes immediately after opening the studio.

Any resolution?

Thanks

I'm having the same problem and it is driving me nuts! I do a lot of BI work and this has disrupted my project timelines significantly.

As best as I can tell. it seems to have start after applying a patch to the .NET framework 2.0. The patch is defined in the KB922770. I'm not sure if this is the culprit by itself or if there are others factors re-enforcing the problem.

Let me know if you come up with a resolution.

Thanks, Darryl

darryl_jewett@.msn.com

|||

We were able to reduce the occurrence of hangup by 90% with two settings... particulary with the first one.

1. Project property -> Configuration Manger - > Build = UNCHECK (This gets checked mysteriously even though we Uncheck and save in TFS - so we verify for this setting frequently when we open the project). If it is checked - all packages in the project are built/compiled irrespective of package you are working on and if there are 100's of packages - compiling all of them takes hell of time.

2. Tools->Options->Environment->AutoRecovery - Save autorecovery information... = UNCHECK. (I did this bz I saw in the status bar of VS the message: Saving autorecovery details.. when it gets stuck)

Hope it helps you as well (if above setting are not important to you ).

But the problem has not gone altogether.... it still hangs up once in a while.

Thanks

Development/Production Environment with Visual Source Safe

Am new to RS. Installed it on test server and was quickly able to
generate a report with multiple datasources and even write some code to
render it directly to a PDF file. Quite a useful and efficient tool.
Now, we want to bring RS into our development environment. We have
multiple developers working on an internal web app in VS.NET that we
want to incorporate reports into. Developers use Visual Source Safe to
bring project files from the development server to their own machines
to do development and then check changes back into the development
server. Periodically, our app is release from development to
production. Pretty straightforward.
What I'm curious about is:
(1) Does SourceSafe version control the report definitions? They look
like files in VS .NET but they reside in the RS database, so I'm
uncertain.
(2) Can developers install RS on their machines for developing reports
under VS.NET while using the RS server/database on the development
server for previewing?
Thanks.
JeffAnswers to your questions:
1. You can (and should) check reports, report projects, report
solutions--however you want to organize it--into VSS. But it is a separate
process that you have to enforce with policy and procedure as VSS will not
reach into the report catalog (database) and handle versioning there.
2. Yes. If your developers have VS.NET 2003, then just install any version
of Reporting Services on their workstations, just unselect and server
components if they are offered in the setup.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"JeffW" <jwilson@.telnetww.com> wrote in message
news:1110499289.694022.73370@.g14g2000cwa.googlegroups.com...
> Am new to RS. Installed it on test server and was quickly able to
> generate a report with multiple datasources and even write some code to
> render it directly to a PDF file. Quite a useful and efficient tool.
> Now, we want to bring RS into our development environment. We have
> multiple developers working on an internal web app in VS.NET that we
> want to incorporate reports into. Developers use Visual Source Safe to
> bring project files from the development server to their own machines
> to do development and then check changes back into the development
> server. Periodically, our app is release from development to
> production. Pretty straightforward.
> What I'm curious about is:
> (1) Does SourceSafe version control the report definitions? They look
> like files in VS .NET but they reside in the RS database, so I'm
> uncertain.
> (2) Can developers install RS on their machines for developing reports
> under VS.NET while using the RS server/database on the development
> server for previewing?
> Thanks.
> Jeff
>

Development Tools

Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.

Developing CLR Objects - Visual Studio Requirements?

I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
on either system's VS installation the option to create a new Sql
Project/Solution to create CLR objects. Am I missing something, or do I
need VS Professional?
CraigHi Craig,
the option should be under
FIle --> New --> Project --> (Programming Language, e.g. C# ) -->
Database --> SQLServer project
In the Project you can define new object types like functions /
procedures / UDA etc.
HTH, Jens Suessmeyer.|||AFAIK, you need VS Professional version or (beta of) Team System dev.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/bobb
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||You don't need to use Visual Studio to create and run
assemblies in SQL Server:
http://www.eggheadcafe.com/articles...5_clr_regex.asp
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||True. By the description in the posting, it appeared that he was looking for
the built-in Visual Studio "SQL Server Projects" for .NET languages, that
are included as part of some editions of Visual Studio.
You could conceivably develop and deploy SQLCLR assemblies with a command
line compiler and SQLCMD.exe.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
> You don't need to use Visual Studio to create and run
> assemblies in SQL Server:
> http://www.eggheadcafe.com/articles...5_clr_regex.asp
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.eggheadcafe.com/forums/merit.asp
>
>
> "Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
> news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>|||Niels Berglund has released an custom SQL Server project, VS addin and a
stand-alone SQL CLR deployment tool which work with any edition of Visual
Studio.
http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
David
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
> True. By the description in the posting, it appeared that he was looking
> for the built-in Visual Studio "SQL Server Projects" for .NET languages,
> that are included as part of some editions of Visual Studio.
> You could conceivably develop and deploy SQLCLR assemblies with a command
> line compiler and SQLCMD.exe.
> Cheers,
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
> news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
>|||Yep. I was aware of that too. ;-) It sounded as though the questioner was
asking/wondering why the built-in projects didn't show up, rather than what
are the choices when...
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
> Niels Berglund has released an custom SQL Server project, VS addin and a
> stand-alone SQL CLR deployment tool which work with any edition of Visual
> Studio.
> http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
> David
>
> "Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
> news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
>|||I was kind of asking both, mainly "how do I develop one without notepad.exe"
:) I found all of these posts to be both correct and very helpful, thank
you all.
Craig
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:uCuImBODGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Yep. I was aware of that too. ;-) It sounded as though the questioner was
> asking/wondering why the built-in projects didn't show up, rather than
> what are the choices when...
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
>

Developer Express & Database issues

I Am developing a simple app with a database. All has been going fine until now, the following is occuring:

In Visual Web Developer 2005 Express if I connect to the database and view some table data I can do that fine but then as soon as I try to view a page in the browser I get the error:
Login failed for user 'MachineName\ASPNET'
If in web developer I go to the database explorer and close the connection to the database then refresh the page it all works fine.

Anyone have anyideas on how to correct this?

Thanks
Scott

This is a frequently asked issue The login 'MachineName\ASPNET' is used by IIS when your website trying to connect to SQL with Window Authentication (Integrated Security=SSPI). So in this case just add the account to SQL Server Logins with proper database permissions, which can be easily done in Management Studio: go to Security->Logins->right clich and choose add login->add the Windows account 'MachineName\ASPNET' and give it permissions (or simply add it to sysadmin server role). You can download Management Studio Express from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased
the package Visual Basic Step By Step and put it on the server hoping to ac
cess the SQL Server on the server PC. But VB Step by Step won't recognize th
e SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Se
rver, could I put it on my server or would I have to move VB to my desktop P
C, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC
"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

develop RS2000 report through V Studio.NET 2005

Hi all, is it possible to create RS2000 format reports through Visual Studio
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>