Authentication problem

I am setting up replication for the first time and, as can be expected,
running into problems. The scenario is a server in one domain that will be a
publisher using a remote distributor in a different domain. When trying to
configure the publisher server, I keep getting a 'server does not exist or
access denied' when it tries to configure the remote distributor. I know the
server exists, so I figure I have messed up something in the way they
authenticate with each other. There is a 2-way trust between the domains and
none of the SQL or SQL Agent Services are running under the system accounts.
Any suggestions or links to good info would be most appreciated.
Thanks,
Bob Castleman
DBA Poseur
have a look at this link
http://support.microsoft.com/default...b;en-us;321822
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bob Castleman" <nomail@.here> wrote in message
news:OfeDgG1SFHA.3244@.TK2MSFTNGP15.phx.gbl...
> I am setting up replication for the first time and, as can be expected,
> running into problems. The scenario is a server in one domain that will be
a
> publisher using a remote distributor in a different domain. When trying to
> configure the publisher server, I keep getting a 'server does not exist or
> access denied' when it tries to configure the remote distributor. I know
the
> server exists, so I figure I have messed up something in the way they
> authenticate with each other. There is a 2-way trust between the domains
and
> none of the SQL or SQL Agent Services are running under the system
accounts.
> Any suggestions or links to good info would be most appreciated.
> Thanks,
> Bob Castleman
> DBA Poseur
>
|||THanks!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OZfKQG2SFHA.2128@.TK2MSFTNGP15.phx.gbl...
> have a look at this link
> http://support.microsoft.com/default...b;en-us;321822
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Bob Castleman" <nomail@.here> wrote in message
> news:OfeDgG1SFHA.3244@.TK2MSFTNGP15.phx.gbl...
> a
> the
> and
> accounts.
>

Authentication mode, connecting from webpage

Hello,
I need help setting up SQL Server Express edition.
What I did so far:
1) Downloaded and installed it with windows authentication
2) Installed SQL Server Management Studio Express
3) Created a database
4) Realized I needed SQL Authentication for connecting via php page.
5) Followed these instructions to enable SQL Authentication
Now that SQL Authentication is enabled, how do I create a user account that I can use in php pages to connect to the database?
Thanks,
Kurt

Hey Kurt. See the documentation in Books Online for the following commands:

CREATE LOGIN

CREATE USER

The create login statement will create a user on your server, then run the create user statement to allow that user access to the database(s) on your system.

HTH,

|||Hello,
Ok thanks, I got my user created with the following. I also realized its the same as creating a user in SQL Management Studio Express.
sqlcmd -S .\SQLEXPRESS
1>CREATE LOGIN myuser WITH PASSWORD = 'mypassword';
2>GO
Is there anything else I have to change for php to beable to connect with this user?
Thanks,
Kurt|||

You need to run the CREATE USER command to give the login you just created access to the database(s) you want it to have access to. Then you have to provide the appropriate permissions to that user within the database in question (i.e. select from tables, update tables, delete tables and records, etc., etc.)

|||Hi Chad,
I keep getting an error when I try to connect from a webpage. For the server can I use localhost?
Warning: mssql_connect(): Unable to connect to server: localhost in D:\wwwRoot\db\connect.php on line 18

Thanks,
Kurt

Attribute AggregationUsage Setting

I can't figure out where to set the aggregationussage property of an attribute to unrestricted?

In the cube designer in BIDS. Open the cube designer. Go to the cube structure tab. In the bottom-left, select Dimension Attributes. Expand a dimension, highlight an attribute, and open its properties. The property should be at the top.

B.