Remote User

Hi, im new to here and SQL server.

I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.

Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.

Thanks in advance for reply's

Regards
Matt

Hi,

As you said your machines are not on domain network, so you can not add the windows users to your server, rather you may add sql server login(s) in this case. Add the machine(s) to doamains so that they appears or else you need to create a windows login on your sql server machine with the same user id /password as they are on your workgroup machine. I.E. the name of your machine on workgroup is MachA and it has a user "squser1" and password "squser1", you need to create a windows user on your sql server with same username "squser1" and password "squser1" , But the best bet is to add those machine on your domain and then add/map the users to your sql server.

|||

Hi, thanks for your reply.

You have said

Hemantgiri S. Goswami wrote:

Add the machine(s) to doamains so that they appears

This is what I want to know how to do.

In theory should the workgroup computers automatically be added to the listed locations on the add login window or is there a process I must go through to get them on there. As I stated before I can see the other computers in the network places > view workgroup computers.

Regards

Matt

|||I have solved my problem. I was trying to add sql user with windows domain and account details and it was throwing an error at this. This post just illustrates my inexperience with SQL.

Thanks anyway for the reply

Remote User

Hi, im new to here and SQL server.

I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.

Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.

Thanks in advance for reply's

Regards
Matt

Hi,

As you said your machines are not on domain network, so you can not add the windows users to your server, rather you may add sql server login(s) in this case. Add the machine(s) to doamains so that they appears or else you need to create a windows login on your sql server machine with the same user id /password as they are on your workgroup machine. I.E. the name of your machine on workgroup is MachA and it has a user "squser1" and password "squser1", you need to create a windows user on your sql server with same username "squser1" and password "squser1" , But the best bet is to add those machine on your domain and then add/map the users to your sql server.

|||

Hi, thanks for your reply.

You have said

Hemantgiri S. Goswami wrote:

Add the machine(s) to doamains so that they appears

This is what I want to know how to do.

In theory should the workgroup computers automatically be added to the listed locations on the add login window or is there a process I must go through to get them on there. As I stated before I can see the other computers in the network places > view workgroup computers.

Regards

Matt

|||I have solved my problem. I was trying to add sql user with windows domain and account details and it was throwing an error at this. This post just illustrates my inexperience with SQL.

Thanks anyway for the reply

Remote User

Hi, im new to here and SQL server.

I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.

Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.

Thanks in advance for reply's

Regards
Matt

Hi,

As you said your machines are not on domain network, so you can not add the windows users to your server, rather you may add sql server login(s) in this case. Add the machine(s) to doamains so that they appears or else you need to create a windows login on your sql server machine with the same user id /password as they are on your workgroup machine. I.E. the name of your machine on workgroup is MachA and it has a user "squser1" and password "squser1", you need to create a windows user on your sql server with same username "squser1" and password "squser1" , But the best bet is to add those machine on your domain and then add/map the users to your sql server.

|||

Hi, thanks for your reply.

You have said

Hemantgiri S. Goswami wrote:

Add the machine(s) to doamains so that they appears

This is what I want to know how to do.

In theory should the workgroup computers automatically be added to the listed locations on the add login window or is there a process I must go through to get them on there. As I stated before I can see the other computers in the network places > view workgroup computers.

Regards

Matt

|||I have solved my problem. I was trying to add sql user with windows domain and account details and it was throwing an error at this. This post just illustrates my inexperience with SQL.

Thanks anyway for the reply

Remote hosted SQL server - approach?

I have been happily using RS (SQL200) on one of our local servers for some time. However, we have SQL2000 installed on a hosted, managed remote server for some applications we provide.

We need to report on the data so the obvious decision was to get RS installed on the remote machine so I could design and deploy the necessary reports from here to RS on the hosted server.

However, for various reasons (that I do not fully understand) the default install of RS does not work on the remote server and the hsoiting company won't install it in anything other than it's default dormat. So our original plan seems to be stuffed.

What are options here? It was suggested that we could 'replicate' the hosed server data to my 'local' SQL server but that seems to have hit a brick wall too.

What would I need to do to report using the 'local' RS against the 'remote' data - is this possible?

bump?

Remote Error Problem

Hi all,
I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors):

An error has occurred during report processing.

Cannot create a connection to data source 'SSIS'.

5 Anyone have any idea how to solve it? or anywhere that I can find the meaning of the 5 below the error message? Thanks in advance.
Daren
Hi all,
Sorry to post another message here. Just to touch up on my question above. I create a custom data source to SSIS in Report Server and use Windows Integrated Security. Then the error occurs.
Daren
|||Nobody knows about this error?
Daren
|||Have you looked at the logfiles?
\Program Files\Microsoft SQL Server\MSSQL.[x]\Reporting Services\LogFiles
The logfiles get really big and complex, so the best way is to stop IIS and Reporting Services, move or delete the old logfiles, restart the IIS and Reporting Services, run your report and look into the logfiles. Usually you can find a bit more verbose Errormessages there.

|||Hi BenniG,
Sorry I took so long to reply, I managed to browse through the log and found the following content:
w3wp!processing!7!5/18/2006-09:27:24:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
at MgdParser.CreatePackage(Boolean bNeutral, Boolean bRemote)
at Microsoft.SqlServer.Dts.DtsClient.DtsConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionWrapper.Open()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
End of inner exception stack trace
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: Data source 'SSIS': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: An exception has occurred in data source 'SSIS'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
w3wp!processing!7!5/18/2006-09:27:25:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
End of inner exception stack trace
w3wp!webserver!7!05/18/2006-09:27:25:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
But I still do not get what does System.ApplicationException: 5 means. Do you know anywhere that I can find the description of error #5 stated in the log or report server?
Daren
|||Can you post these messages to the SSIS forum? You should be able to get a better response there.|||ok. Thanks Tudor.
Daren

Remote Error Problem

Hi all,
I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors):

An error has occurred during report processing.

Cannot create a connection to data source 'SSIS'.

5 Anyone have any idea how to solve it? or anywhere that I can find the meaning of the 5 below the error message? Thanks in advance.
Darenanyone know the solution to it?
Daren

Remote Error Problem

Hi all,
I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors):

An error has occurred during report processing.

Cannot create a connection to data source 'SSIS'.

5 Anyone have any idea how to solve it? or anywhere that I can find the meaning of the 5 below the error message? Thanks in advance.
Daren
Hi all,
Sorry to post another message here. Just to touch up on my question above. I create a custom data source to SSIS in Report Server and use Windows Integrated Security. Then the error occurs.
Daren
|||Nobody knows about this error?
Daren
|||Have you looked at the logfiles?
\Program Files\Microsoft SQL Server\MSSQL.[x]\Reporting Services\LogFiles
The logfiles get really big and complex, so the best way is to stop IIS and Reporting Services, move or delete the old logfiles, restart the IIS and Reporting Services, run your report and look into the logfiles. Usually you can find a bit more verbose Errormessages there.

|||Hi BenniG,
Sorry I took so long to reply, I managed to browse through the log and found the following content:
w3wp!processing!7!5/18/2006-09:27:24:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
at MgdParser.CreatePackage(Boolean bNeutral, Boolean bRemote)
at Microsoft.SqlServer.Dts.DtsClient.DtsConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionWrapper.Open()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
End of inner exception stack trace
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: Data source 'SSIS': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: An exception has occurred in data source 'SSIS'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
w3wp!processing!7!5/18/2006-09:27:25:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
End of inner exception stack trace
w3wp!webserver!7!05/18/2006-09:27:25:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
But I still do not get what does System.ApplicationException: 5 means. Do you know anywhere that I can find the description of error #5 stated in the log or report server?
Daren
|||Can you post these messages to the SSIS forum? You should be able to get a better response there.|||ok. Thanks Tudor.
Daren