Can't deploy from local machine

Can anyone help me. I work in a workgroup environment as opposed to domain
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>

Cant Connect to remote server, my app works in local only??

Hello,
i've developed a website using VB.NET, and SQL SERVER 2K, in my dev environment works properly (SQL Server and WEB SERVER are in the same machine).
When i put everything in the target machine, where the webserver is but not the sql, i get the following error:
Sql SErver does not exist or access denied

I've tried so many ways to do this, ODBC, ADO.NET, OLEDB....and everything ends in the same error.
Also if i try to connect with ODBC (from odbc manager) it seems to work (test connection succesfull), but in asp.net nothing works.
I've tried to access the server with:
INSTANCE_NAME
\SERVER_NAME\INSTANCE_NAME
IP,PORT

I think (they are checking this), that the auth mode is set to MIXED MODE.

Any idea to save my life?? ;)

Thanks pplYour reference to the server in your ADO connection string should be:

ipaddressofserver\instancename (i.e., 206.152.125.6\instance1 )

If you are using SQL Authenticiation, which you should, then you need to reference the {uid} and {password} properties.
I would be willing to bet that your SQL Installation is set the Mixed Mode.

HTH