Showing posts with label home. Show all posts
Showing posts with label home. Show all posts

Wednesday, March 21, 2012

name of instance

I just setup a new database machine... in my home environment
and want to test replication and subscribion
I am using windows 2003 server and sql 2000 server,
i have create a instance name while installion... but after around 15
days...
the instance name automatic changed to "local".. and then I can not create a
replication anymore because the sql server said that "local" can as a name
of distributor ...
any anyone tell me what i can/should do?
Many Thanks..
Thanks in advanced.
Hi
If the instance is called (local) this would imply a default instance and
not a named instance! You can refer to a default instance by the machine name.
John
"beachboy" wrote:

> I just setup a new database machine... in my home environment
> and want to test replication and subscribion
> I am using windows 2003 server and sql 2000 server,
> i have create a instance name while installion... but after around 15
> days...
> the instance name automatic changed to "local".. and then I can not create a
> replication anymore because the sql server said that "local" can as a name
> of distributor ...
> any anyone tell me what i can/should do?
> Many Thanks..
> Thanks in advanced.
>
>

name of instance

I just setup a new database machine... in my home environment
and want to test replication and subscribion
I am using windows 2003 server and sql 2000 server,
i have create a instance name while installion... but after around 15
days...
the instance name automatic changed to "local".. and then I can not create a
replication anymore because the sql server said that "local" can as a name
of distributor ...
any anyone tell me what i can/should do?
Many Thanks..
Thanks in advanced.Hi
If the instance is called (local) this would imply a default instance and
not a named instance! You can refer to a default instance by the machine nam
e.
John
"beachboy" wrote:

> I just setup a new database machine... in my home environment
> and want to test replication and subscribion
> I am using windows 2003 server and sql 2000 server,
> i have create a instance name while installion... but after around 15
> days...
> the instance name automatic changed to "local".. and then I can not create
a
> replication anymore because the sql server said that "local" can as a name
> of distributor ...
> any anyone tell me what i can/should do?
> Many Thanks..
> Thanks in advanced.
>
>

name of instance

I just setup a new database machine... in my home environment
and want to test replication and subscribion
I am using windows 2003 server and sql 2000 server,
i have create a instance name while installion... but after around 15
days...
the instance name automatic changed to "local".. and then I can not create a
replication anymore because the sql server said that "local" can as a name
of distributor ...
any anyone tell me what i can/should do?
Many Thanks..
Thanks in advanced.Hi
If the instance is called (local) this would imply a default instance and
not a named instance! You can refer to a default instance by the machine name.
John
"beachboy" wrote:
> I just setup a new database machine... in my home environment
> and want to test replication and subscribion
> I am using windows 2003 server and sql 2000 server,
> i have create a instance name while installion... but after around 15
> days...
> the instance name automatic changed to "local".. and then I can not create a
> replication anymore because the sql server said that "local" can as a name
> of distributor ...
> any anyone tell me what i can/should do?
> Many Thanks..
> Thanks in advanced.
>
>

Friday, March 9, 2012

MySql

I am setting up a message board on my home windows 2000 server with IIS. I installed PHP and got that to work and now i need to set up a mysql database. How do i go about doing that, i installed the mysql software but im stuck from there.Hello,

after installation you can access every object in the MySQL. Normally the server starts automatically. If you want to create a database or access your datas (create table and so on) use AlligatorSQL at http://www.alligatorsql.com/download/alligator.zip

AlligatorSQL supports also MSSQL7 and SQL2000 databases.

Hope that helps otherwise describe your problem with more details.

Regards

Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com