problem with SQL-Server 2005 CTP

I have received visual studio 2005 beta experience kit. My kit included a version of MS SQL-Server 2005 Developer Edition CTP ( Developer Edition printed on the surface of my DVD but I don't know it's true or not ? because I saw this page: http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx and there was not Developer Edition). I had a new and fresh Windows 2003 (without SP1) installed on one of my office PCs. So I decided to install visual studio 2005 beta 2 first and then SQL-Server 2005 CTP. But after I installed SQL-Server 2005 CTP I saw nothing in my start menu even Express Manager. My question is : how can I find SQL-Server Express Manager or Management Studio . is my problem related to installing Visual Studio 2005 Before SQL-Server like this topic: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=17309

If it is how can I fix this problem?

Excuse me for my bad English writing!

thank you!

You should try posting this question to SQL Server Setup & Upgrade forum.

Thanks,
-Vineet Rao

Problem with SQLServer 2000

i installed the Visual Studio 2004+ Framework.NET 2

and SQLserver 2005

after those

i installed SQLserver 2000

and i got this :

http://img240.imageshack.us/img240/7392/sql2fk.jpg

thank you

This is the wrong forum. From your screenshot it looks like you should be checking the Express forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=385&SiteID=1

In the meantime, have you checked in the Services panel that SQL Server is running?

Have you enabled remote conenctions using the Surface Area configuraiton tool?

-Jamie

|||what should i change here?

http://img86.imageshack.us/img86/746/remote6np.jpg

thank you|||

From the screenshot http://img240.imageshack.us/img240/7392/sql2fk.jpg - it looks like you are trying to access SQL Server 2005 Express Edition from SQL Server Enterprise Manager.

Try accessing SQL Server 2005 express edition from SQL Server Management Studio (which is equivalent of SQL Server 2000 Enterprise manager for SQL Server 2005.)

Thanks,
Loonysan

|||i dont know what do u mean...

i even dont need SQL server 2005 i need only the 2000...

but i have heard that removing SQL server 2005 from my computer wont work...

can someone give me step by step what to do to solve the problem...

thank you :D|||

deViance wrote:

i dont know what do u mean...
i even dont need SQL server 2005 i need only the 2000...
but i have heard that removing SQL server 2005 from my computer wont work...
can someone give me step by step what to do to solve the problem...

thank you :D

For a starter, you are in the wrong place.

If you don't need SQL2005 why did you install it? What exactly are you trying to do?

-Jamie

Problem with SQL Server Managment Studio Express CTP

Hi, I have installed the product in subject but after installation if a click on program to use it, i have no result.

Someone can tell me how i can control why it no work?

The real problem is that it no give me an error code simply the program not start.?!?!?

Thank's for your attention.

By Fabrizio

I find...

When you downloaded the updated Management Studio Express, did you see it take some time to download it again, or did it start immediately? (If it starts immediately, you're running a cached copy of the Windows installer package for SSMSE.)

If you rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" registry key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX" using regedit, SSMSE should start. This should not affect the stand-alone Books Online at all.

After you rename the registry key and then start Management Studio Express, does the splash Screen say "SQL Server Management Studio Express Edition" or just "Management Studio Express"? The November 11 download says "Management Studio Express."

Problem with SQL Server and odbc, please help me!

I have Visual Studio Dot.Net on Win XP and use the MSDE to access to Sql
Server.
This morning I've attempt to create a new ODBC DSN for Sql Server so
I've executed the wizard for a new System DSN by the ODBC administrator
of Windows. But when it attempts to connect to the server (the third
step of wizard) it give me somewhat like:
Connection impossible.
SQLState: '01000'
SQL Server error: 10049
SQLState: '08001'
SQL Server error: 17
I've tried to go forward with the manual configuration (uncheck the item
"Connect to an SQL Server for the default settings.." and press the Next
button), but at the end, when I press "Verify the data source", I have
no connection. So I've canceled the wizard.
The problem is that after that moment I have no connection with the server.
The console of MSDE indicate that the server is normally running, but I
can't connect to it neither by the Server Explorer of VS nor by osql.
I have always a message like:
[DBNETLIB][ConnectionOpen(Connect()).]Server non found or access denied.
Can someone help me?
Thanks
Tonio Tanzi
P.s. the messages of the server are probably a little different by the
ones indicate by me because I've translated them from the italian version.Tonio,
Is this a development server? If so try stopping the SQL Server service and
restarting it.
HTH
Jerry
"Tonio Tanzi" <vi.tan.gr@.inwind.it> wrote in message
news:m8c%e.3633$EZ.98724@.twister1.libero.it...
>I have Visual Studio Dot.Net on Win XP and use the MSDE to access to Sql
>Server.
> This morning I've attempt to create a new ODBC DSN for Sql Server so I've
> executed the wizard for a new System DSN by the ODBC administrator of
> Windows. But when it attempts to connect to the server (the third step of
> wizard) it give me somewhat like:
> Connection impossible.
> SQLState: '01000'
> SQL Server error: 10049
> SQLState: '08001'
> SQL Server error: 17
> I've tried to go forward with the manual configuration (uncheck the item
> "Connect to an SQL Server for the default settings.." and press the Next
> button), but at the end, when I press "Verify the data source", I have no
> connection. So I've canceled the wizard.
> The problem is that after that moment I have no connection with the
> server.
> The console of MSDE indicate that the server is normally running, but I
> can't connect to it neither by the Server Explorer of VS nor by osql.
> I have always a message like:
> [DBNETLIB][ConnectionOpen(Connect()).]Server non found or access denied.
>
> Can someone help me?
> Thanks
> Tonio Tanzi
> P.s. the messages of the server are probably a little different by the
> ones indicate by me because I've translated them from the italian version.|||Jerry Spivey ha scritto:
> Tonio,
> Is this a development server? If so try stopping the SQL Server service a
nd
> restarting it.
Yes. I've just stopped and restarted both Sql Server and computer many
times widhout any result.
Other suggest?
Bye
Tonio Tanzi

Problem with SQL Dependency

Hi -

I am trying to set up a SQL dependency using VS Studio 2005 and SQL Server 2005, Dev Ed. My problem is that the handler for the onchange event never gets called, and the SQL Service Broker statistics report shows it as disabled.

This is really vexing because this is what I have done:

The service broker was enabled using this:

use masteralterdatabase mydatabaseSET ENABLE_BROKER

which I can verify by using:select is_broker_enabled from sys.databases where name = ''mydatabase', which results 1.

I've also given the user the right permissions, I believe, like this:

use mydatabase

GRANT CREATE PROCEDURE TO myuser
GRANT CREATE QUEUE TO myuser
GRANT CREATE SERVICE TO myuser

This isn't doing me any good, it seems, although I took care to log in as myuser. The connection works, and I can read/write data from the db. However the following code does not seem to do anything:

Public Sub StartListening()If IsNothing(Dependency)Then Dim cAs New SqlClient.SqlCommand("SELECT Messages.ID, Messages.TimeInitiated, Messages.TimeToSend, Messages.TimeSent FROM(Messages)") Dependency =New SqlClient.SqlDependency(c)AddHandler Dependency.OnChange,AddressOf UpdateMessages SqlClient.SqlDependency.Start(LoadConnectionString)End If Messages = MessageTA.GetDataEnd Sub Public Sub UpdateMessages(ByVal senderAs Object,ByVal eAs System.Data.SqlClient.SqlNotificationEventArgs)Dim i = 1End Sub

Or at least my breakpoint in UpdateMessages is never reached.

ANY HELP OR IDEAS AS TO WHAT I AM MISSING IS HIGHLY APPRECIATED!!!

Thanks,

Oliver

Have you enabled both your database and tables for change notifiations?

Have a look at this article. It should help you.

http://www.ondotnet.com/pub/a/dotnet/2005/01/17/sqlcachedependency.html

Problem with SQL 2005 install. Can Microsoft.SqlServer.MSMQTask.dll be recovered?

Hello!
I am trying to install SQL Server 2005 (Developer Edition -- the version
that came with my Visual Studio 2005 Professional Edition software).
For the most part, the install went pretty smoothly. However, during the
Integration Services portion, I got the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.d ll in the COM+ catalog.
Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task. Contact your system administrator for assistance.
I Googled for some solutions, and came up with a few relevant hits:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
I tried the suggestions therein, but none of them seemed to solve the
problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
in my COM+ list). I couldn't hit "Retry" during the SQL installation and
have it gracefully resume.
I eventually just hit Ignore, and the rest of the install proceeded just
fine.
I'm wondering if there's any way to recover this file and/or COM+ entry?
I'm guessing that it's necessary for Integration Services?
(BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
installed at one point, too, but uninstalled before installing the current
version.)
Thanks for any help anyone can provide!
John Peterson
Hi
"John Peterson" wrote:

> Hello!
> I am trying to install SQL Server 2005 (Developer Edition -- the version
> that came with my Visual Studio 2005 Professional Edition software).
> For the most part, the install went pretty smoothly. However, during the
> Integration Services portion, I got the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.d ll in the COM+ catalog.
> Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: You must have administrative credentials to perform this
> task. Contact your system administrator for assistance.
> I Googled for some solutions, and came up with a few relevant hits:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
> I tried the suggestions therein, but none of them seemed to solve the
> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
> in my COM+ list). I couldn't hit "Retry" during the SQL installation and
> have it gracefully resume.
> I eventually just hit Ignore, and the rest of the install proceeded just
> fine.
> I'm wondering if there's any way to recover this file and/or COM+ entry?
> I'm guessing that it's necessary for Integration Services?
> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
> installed at one point, too, but uninstalled before installing the current
> version.)
> Thanks for any help anyone can provide!
> John Peterson
Have you tried a re-install
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
John
|||John,
Thanks for the reply! I've got two questions:
If I re-install, will it correctly detect the components to re-install, even
if I've already upgraded to SP2 (and the critical update for SP2)?
What exactly is Integration Services in SQL 2005? Is that sort of like the
DTS replacement? If so, is the absence of this COM+ object going to be a
hindrance?
Kind regards,
John Peterson
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
> Hi
> "John Peterson" wrote:
>
> Have you tried a re-install
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
> John
|||Oh -- I also meant to ask whether I could expect the previous error to "go
away" if I were to try and re-install, or if it would likely pop up again?
Now that I've done a little more research on Integration Services (also
known as SSIS), it looks like it is a DTS replacement (and more). As such,
I know that I'll need to be using this component -- so if I can resolve this
installation error, I'll be a happy camper. :-)
Thanks for any additional help you (or any others) can provide!
John Peterson
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23unJK%234fHHA.1216@.TK2MSFTNGP03.phx.gbl...
> John,
> Thanks for the reply! I've got two questions:
> If I re-install, will it correctly detect the components to re-install,
> even if I've already upgraded to SP2 (and the critical update for SP2)?
> What exactly is Integration Services in SQL 2005? Is that sort of like
> the DTS replacement? If so, is the absence of this COM+ object going to
> be a hindrance?
> Kind regards,
> John Peterson
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
>

Problem with SQL 2005 install. Can Microsoft.SqlServer.MSMQTask.dll be recovered?

Hello!
I am trying to install SQL Server 2005 (Developer Edition -- the version
that came with my Visual Studio 2005 Professional Edition software).
For the most part, the install went pretty smoothly. However, during the
Integration Services portion, I got the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task. Contact your system administrator for assistance.
I Googled for some solutions, and came up with a few relevant hits:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
I tried the suggestions therein, but none of them seemed to solve the
problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
in my COM+ list). I couldn't hit "Retry" during the SQL installation and
have it gracefully resume.
I eventually just hit Ignore, and the rest of the install proceeded just
fine.
I'm wondering if there's any way to recover this file and/or COM+ entry?
I'm guessing that it's necessary for Integration Services?
(BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
installed at one point, too, but uninstalled before installing the current
version.)
Thanks for any help anyone can provide!
John PetersonHi
"John Peterson" wrote:
> Hello!
> I am trying to install SQL Server 2005 (Developer Edition -- the version
> that came with my Visual Studio 2005 Professional Edition software).
> For the most part, the install went pretty smoothly. However, during the
> Integration Services portion, I got the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
> Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: You must have administrative credentials to perform this
> task. Contact your system administrator for assistance.
> I Googled for some solutions, and came up with a few relevant hits:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
> I tried the suggestions therein, but none of them seemed to solve the
> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
> in my COM+ list). I couldn't hit "Retry" during the SQL installation and
> have it gracefully resume.
> I eventually just hit Ignore, and the rest of the install proceeded just
> fine.
> I'm wondering if there's any way to recover this file and/or COM+ entry?
> I'm guessing that it's necessary for Integration Services?
> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
> installed at one point, too, but uninstalled before installing the current
> version.)
> Thanks for any help anyone can provide!
> John Peterson
Have you tried a re-install
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
John|||John,
Thanks for the reply! I've got two questions:
If I re-install, will it correctly detect the components to re-install, even
if I've already upgraded to SP2 (and the critical update for SP2)?
What exactly is Integration Services in SQL 2005? Is that sort of like the
DTS replacement? If so, is the absence of this COM+ object going to be a
hindrance?
Kind regards,
John Peterson
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
> Hi
> "John Peterson" wrote:
>> Hello!
>> I am trying to install SQL Server 2005 (Developer Edition -- the version
>> that came with my Visual Studio 2005 Professional Edition software).
>> For the most part, the install went pretty smoothly. However, during the
>> Integration Services portion, I got the following error:
>> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
>> Error: -2146233087
>> Error message: Unknown error 0x80131501
>> Error description: You must have administrative credentials to perform
>> this
>> task. Contact your system administrator for assistance.
>> I Googled for some solutions, and came up with a few relevant hits:
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
>> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
>> I tried the suggestions therein, but none of them seemed to solve the
>> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask
>> entry
>> in my COM+ list). I couldn't hit "Retry" during the SQL installation and
>> have it gracefully resume.
>> I eventually just hit Ignore, and the rest of the install proceeded just
>> fine.
>> I'm wondering if there's any way to recover this file and/or COM+ entry?
>> I'm guessing that it's necessary for Integration Services?
>> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
>> installed at one point, too, but uninstalled before installing the
>> current
>> version.)
>> Thanks for any help anyone can provide!
>> John Peterson
> Have you tried a re-install
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
> John|||Oh -- I also meant to ask whether I could expect the previous error to "go
away" if I were to try and re-install, or if it would likely pop up again?
Now that I've done a little more research on Integration Services (also
known as SSIS), it looks like it is a DTS replacement (and more). As such,
I know that I'll need to be using this component -- so if I can resolve this
installation error, I'll be a happy camper. :-)
Thanks for any additional help you (or any others) can provide!
John Peterson
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23unJK%234fHHA.1216@.TK2MSFTNGP03.phx.gbl...
> John,
> Thanks for the reply! I've got two questions:
> If I re-install, will it correctly detect the components to re-install,
> even if I've already upgraded to SP2 (and the critical update for SP2)?
> What exactly is Integration Services in SQL 2005? Is that sort of like
> the DTS replacement? If so, is the absence of this COM+ object going to
> be a hindrance?
> Kind regards,
> John Peterson
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
>> Hi
>> "John Peterson" wrote:
>> Hello!
>> I am trying to install SQL Server 2005 (Developer Edition -- the version
>> that came with my Visual Studio 2005 Professional Edition software).
>> For the most part, the install went pretty smoothly. However, during
>> the
>> Integration Services portion, I got the following error:
>> Failed to install and configure assemblies C:\Program Files\Microsoft
>> SQL
>> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+
>> catalog.
>> Error: -2146233087
>> Error message: Unknown error 0x80131501
>> Error description: You must have administrative credentials to perform
>> this
>> task. Contact your system administrator for assistance.
>> I Googled for some solutions, and came up with a few relevant hits:
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
>> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
>> I tried the suggestions therein, but none of them seemed to solve the
>> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask
>> entry
>> in my COM+ list). I couldn't hit "Retry" during the SQL installation
>> and
>> have it gracefully resume.
>> I eventually just hit Ignore, and the rest of the install proceeded just
>> fine.
>> I'm wondering if there's any way to recover this file and/or COM+ entry?
>> I'm guessing that it's necessary for Integration Services?
>> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005
>> CTP
>> installed at one point, too, but uninstalled before installing the
>> current
>> version.)
>> Thanks for any help anyone can provide!
>> John Peterson
>> Have you tried a re-install
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
>> John
>sql

problem with Server Management Studio Express and diagrames

so I have had a database in Sql Server 2000, in my DB i have made database diagrams.

now I have installed on other PC(where does't install sql 2000) Sql Server Management Studio Express where I have opened my db , bat db diagrams does't work.

what can I do? how can I solve this problem?

enyone can explain me?

thanks.

Management Studio can't open SQL 2000 diagrams, if you click on the diagrams branch of the tree it should ask if you want to install diagram support, once this is done you can create new diagrams.|||ok, bat when I opend diagrams branch of the tree, it doesn't ask if I want or not to install diagram|||

hi,

usually you have to first import the database to the new SQL Server 2005 instance (as you already did)..

then modify the compatibility level to 90 via the SSMSE, database properties (options tab), and finally set the database owner to a valid principal, again SSMSE, database properties (files tab, "owner" peroperty )...

then you should be able to access database diagrams..

regards

Problem with reportfooter and header

Dear sir,

i am developing reports in sql server businessintelligence development studio...i deployed the reports in reportserver and i was able to see it..but my requirement is all my reports should have the same header and footer as of all other pages must uses custom footers and headers....hw to use thatcustom footer and header in my reports

Regards,

Pradeep

Hi,

do you want to create custom report headers or use the same for all reports ? This is not quite clear.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

dear ,

other than reports pages i have some other pages in that footer and headers(company logo and the project name like that)...i want o use the same thing in my reports

|||Hi,

I always do that by building a report template for portraint as well as for landscape and build my reports on top of that. Once the report design is signed off by anyone who is responsible you can be sure (or a bit more sure) that anything will change afterwards.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Problem with Remote Connections with SQL Server 2005 Standard Edition

After applying the changes mentioned in KB 914277 to allow remote connections, while working in Visual Studio 2005, I'm now getting an error with the number 26: Error locating server/Instance specified...

Sure wish I knew what remote means in this scenario, as there is nothing "remote" about my installation. I only have 1 computer, the one i'm working on, where SQL Server and Visual Studio are installed, and no networks involved, so what is remote?

Any help would be appreciated!!

If the sql server you are trying to connect to and the app you are running are on the same physical machine then you do not need to config remote connections.

Can you check if the SQL Server is still running via the services.msc or config manager first of all.

|||

If there is a way of telling SQL Server that I don't need any remote connection, I'd be more than happy to use it.

However I don't know how to do that... therefore I got the error-message about the remote connection.

How do I tell SQL Server there is no need for a remote connection?

Thanx!!

|||Use the surface area config tool|||

And then...

Check what, click what, do what?

I've only been able to install SQL Server, with a lot of coaching from this forum, I've never used it, and have no idea what makes it or any of it's utilities tick...

I'm thankful for any advice I've been given, but I have no idea what to do with the Surface Area tool, when I get there...

|||

Hello Layne - I got your e-mail about still not being able to connect. Without more information, this will be hard for everyone to help you with. But before I give you some more pointers, you should know about a couple of things.

First, this isn't the primary mechanism for support for Microsoft products. Everyone here is happy to help out where we can, but it's a free site where Microsoft and other database folks will try and help you. We'll do what we can to help you, but there are no guarantees. Microsoft hosts these sites (again, at no cost to you) but this isn't the primary method they support their products. If you need immediate assistance you can check out several support options at http://www.microsoft.com/support.

I also think the comments in your e-mail to me about "all of us going back to India" isn't very polite. If you're asking for help (for free), you may want to be complimentary rather than derogatory. It will get you more answers faster to be polite to others.

The best place for you to look for what you're asking is:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

It's on Express, but will help you with your edition as well.

|||

If the problem is just remote connection is not allowed on the remote server read and check whether the remote server is configured as in the following article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx but it seems that you are hitting another problem

Problem with Remote Connections with SQL Server 2005 Standard Edition

After applying the changes mentioned in KB 914277 to allow remote connections, while working in Visual Studio 2005, I'm now getting an error with the number 26: Error locating server/Instance specified...

Sure wish I knew what remote means in this scenario, as there is nothing "remote" about my installation. I only have 1 computer, the one i'm working on, where SQL Server and Visual Studio are installed, and no networks involved, so what is remote?

Any help would be appreciated!!

If the sql server you are trying to connect to and the app you are running are on the same physical machine then you do not need to config remote connections.

Can you check if the SQL Server is still running via the services.msc or config manager first of all.

|||

If there is a way of telling SQL Server that I don't need any remote connection, I'd be more than happy to use it.

However I don't know how to do that... therefore I got the error-message about the remote connection.

How do I tell SQL Server there is no need for a remote connection?

Thanx!!

|||Use the surface area config tool|||

And then...

Check what, click what, do what?

I've only been able to install SQL Server, with a lot of coaching from this forum, I've never used it, and have no idea what makes it or any of it's utilities tick...

I'm thankful for any advice I've been given, but I have no idea what to do with the Surface Area tool, when I get there...

|||

Hello Layne - I got your e-mail about still not being able to connect. Without more information, this will be hard for everyone to help you with. But before I give you some more pointers, you should know about a couple of things.

First, this isn't the primary mechanism for support for Microsoft products. Everyone here is happy to help out where we can, but it's a free site where Microsoft and other database folks will try and help you. We'll do what we can to help you, but there are no guarantees. Microsoft hosts these sites (again, at no cost to you) but this isn't the primary method they support their products. If you need immediate assistance you can check out several support options at http://www.microsoft.com/support.

I also think the comments in your e-mail to me about "all of us going back to India" isn't very polite. If you're asking for help (for free), you may want to be complimentary rather than derogatory. It will get you more answers faster to be polite to others.

The best place for you to look for what you're asking is:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

It's on Express, but will help you with your edition as well.

|||

If the problem is just remote connection is not allowed on the remote server read and check whether the remote server is configured as in the following article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx but it seems that you are hitting another problem

Problem with printing report directly to printer

Hello,

I am trying to get a SSRS 2005 report to print from my Visual Studio 2005 C++ application without using the ReportViewer to preview it first. What I have done is created a dll that I call into when I want to access a certain report and print it. While searching around on the internet I found an MSDN article about printing a report without previewing and it had an example in C# code. So I used that as a guide for my C++ code but I am still having problems with rendering the report properly so it can be printed. When I try to render a report using the "Image" format, my streamid string is empty but the byte array that the render routine returns is not. Here is the code I am using, what could be the problem here?

Note: m_Streams is define elsewhere as

array<String^>^ m_Streams = gcnew array<String^>(10);

void Print::Export(LocalReport^ report)

{

array<Warning^>^ Warn = gcnew array<Warning^>(10);

String^ deviceinfo =

"<DeviceInfo>" +

" <OutputFormat>EMF</OutputFormat>" +

" <PageWidth>8.5in</PageWidth>" +

" <PageHeight>11in</PageHeight>" +

" <MarginTop>0.25in</MarginTop>" +

" <MarginLeft>0.25in</MarginLeft>" +

" <MarginRight>0.25in</MarginRight>" +

" <MarginBottom>0.25in</MarginBottom>" +

"</DeviceInfo>";

String^ mimeType;

String^ enc;

String^ FileExt;

array<Byte>^ bytes;

bytes = report->Render("Image",deviceinfo, mimeType, enc, FileExt, m_Streams,Warn); // m_Streams has a length of

return; // 0 after the Render

}

void Print:: PrintPage(System:: Object^ sender, System:: Drawing:: Printing:: PrintPageEventArgs^ ev)

{

Metafile^ pageImage = gcnew Metafile(m_Streams[m_CurrentPage]);

ev->Graphics->DrawImage(pageImage, ev->PageBounds);

m_CurrentPage++;

ev->HasMorePages = (m_CurrentPage < m_Streams->Length);

return;

}

void Print:rintRpt()

{

String^ printerName = "Default";

if (m_Streams->Length < 0)

return;

PrintDocument^ printDoc = gcnew PrintDocument();

if (!printDoc->PrinterSettings->IsValid) {

return;

}

printDoc->PrintPage += gcnew PrintPageEventHandler(this, &Print:: PrintPage);

printDoc->Print();

return;

}

void Print::Run()

{

LocalReport^ report = gcnew LocalReport();

DataSet^ ds = gcnew DataSet();

LoadData(ds);

report->ReportPath = "c:\\bmi\\bulrpt\\Report1.rdlc";

ReportDataSource^ RDS = gcnew ReportDataSource();

RDS->Name = "DataSet1_Subject";

RDS->Value = ds->Tables["Subject"];

report->DataSources->Add(RDS);

Export(report);

PrintRpt();

return;

}

DataTable^ Print:: LoadData(DataSet^ ds)

{

System:: String ^ConnStr = "SELECT * FROM Subject";

SqlConnection^ conn = gcnew SqlConnection("Data Source=JOE-PC\\BMIMSDESERVER; Initial Catalog=stx52013;Integrated Security = TRUE");

SqlCommand^ command = gcnew SqlCommand(ConnStr, conn);

SqlDataAdapter^ adapt = gcnew SqlDataAdapter(command);

adapt->TableMappings->Add("Table", "Subject");

conn->Open();

adapt->Fill(ds);

return ds->Tables["Subject"];

}

I had the same problem with that render method and simply looped until the byte lenth was zero and that worked. There is another example out there that used the second overload of the method that works pretty much as is. In that one you pass a call back event handler.

|||

I've tried to do

bytes = report->Render("Image",deviceinfo, &Print::CreateStream,Warn);

as well but when I compile that I get the error -

error C3374: can't take address of 'Print::CreateStream' unless creating delegate instance

What does this mean?