Showing posts with label alias. Show all posts
Showing posts with label alias. Show all posts

Friday, March 30, 2012

How to create server alias

Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser window
Hi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegr oups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>
|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegr oups.com...
|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>
|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>
|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...

How to create server alias

Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add
a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...

How to create server alias

Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> > Can anyone descrive in principle how a Web server alias is actually set
> > up? How do you get a server alias to point to a particular server with
> > a particular IP address within a large organisation? The outcome being
> > that when a user types the alias url into the address bar, the correct
> > page appears in the browser window
> >|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>> Hi
>> Does it somehow relate to SQL Server?
>>
>> <simonaj30@.yahoo.co.uk> wrote in message
>> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
>> > Can anyone descrive in principle how a Web server alias is actually set
>> > up? How do you get a server alias to point to a particular server with
>> > a particular IP address within a large organisation? The outcome being
>> > that when a user types the alias url into the address bar, the correct
>> > page appears in the browser window
>> >
>|||ok, many thanks
Uri Dimant wrote:
> Well, If I understood you , take a look at Client Network Utility to add a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
> >I would think so, as we use it in our organisation
> > Uri Dimant wrote:
> >> Hi
> >>
> >> Does it somehow relate to SQL Server?
> >>
> >>
> >> <simonaj30@.yahoo.co.uk> wrote in message
> >> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> >> > Can anyone descrive in principle how a Web server alias is actually set
> >> > up? How do you get a server alias to point to a particular server with
> >> > a particular IP address within a large organisation? The outcome being
> >> > that when a user types the alias url into the address bar, the correct
> >> > page appears in the browser window
> >> >
> >|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>> Hi
>> Does it somehow relate to SQL Server?
>>
>> <simonaj30@.yahoo.co.uk> wrote in message
>> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
>> > Can anyone descrive in principle how a Web server alias is actually set
>> > up? How do you get a server alias to point to a particular server with
>> > a particular IP address within a large organisation? The outcome being
>> > that when a user types the alias url into the address bar, the correct
>> > page appears in the browser window
>> >
>sql

Wednesday, March 28, 2012

How to create new alias for Analysis Services 2005

Hello All,

Pl guide me for creating new instance for analysis services 2005.

Deepti

Run SQL Server setup to install additional named instances on your machine.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, March 9, 2012

How to Create a Catalog Alias

Hello,
I have run into a little problem,
We have a Database Catalog named "Product-V1.0", and I need to create a DTS
package. However when I create the SQL connection and point to the Catalog,
it truncates the Catalog name to "Product-V1" removing the ".0" from the
name. Hence I can't connect. I tried to add [] around the Catalog name
without any effect. So firstly is there a way that I can configure the DTS
connection to work with this Catalog name. Alternately I was thinking that
perhaps I could create a Alias name for the Catalog and connect to this
name. I tried to create a linked Server, but creating the Linked server
produced the same result as the DTS and I could not connect.
If possible I would like to find an Alternate to renaming the Database
Catalog name.
Regards,
Bernard.
Hi
You can not create an alias for a DB/catalog.
It is best to follow the standards as described in BOL "Using Identifiers".
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bernard Sircelj" wrote:

> Hello,
> I have run into a little problem,
> We have a Database Catalog named "Product-V1.0", and I need to create a DTS
> package. However when I create the SQL connection and point to the Catalog,
> it truncates the Catalog name to "Product-V1" removing the ".0" from the
> name. Hence I can't connect. I tried to add [] around the Catalog name
> without any effect. So firstly is there a way that I can configure the DTS
> connection to work with this Catalog name. Alternately I was thinking that
> perhaps I could create a Alias name for the Catalog and connect to this
> name. I tried to create a linked Server, but creating the Linked server
> produced the same result as the DTS and I could not connect.
> If possible I would like to find an Alternate to renaming the Database
> Catalog name.
> Regards,
> Bernard.
>
>

How to Create a Catalog Alias

Hello,
I have run into a little problem,
We have a Database Catalog named "Product-V1.0", and I need to create a DTS
package. However when I create the SQL connection and point to the Catalog,
it truncates the Catalog name to "Product-V1" removing the ".0" from the
name. Hence I can't connect. I tried to add [] around the Catalog name
without any effect. So firstly is there a way that I can configure the DTS
connection to work with this Catalog name. Alternately I was thinking that
perhaps I could create a Alias name for the Catalog and connect to this
name. I tried to create a linked Server, but creating the Linked server
produced the same result as the DTS and I could not connect.
If possible I would like to find an Alternate to renaming the Database
Catalog name.
Regards,
Bernard.Hi
You can not create an alias for a DB/catalog.
It is best to follow the standards as described in BOL "Using Identifiers".
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bernard Sircelj" wrote:
> Hello,
> I have run into a little problem,
> We have a Database Catalog named "Product-V1.0", and I need to create a DTS
> package. However when I create the SQL connection and point to the Catalog,
> it truncates the Catalog name to "Product-V1" removing the ".0" from the
> name. Hence I can't connect. I tried to add [] around the Catalog name
> without any effect. So firstly is there a way that I can configure the DTS
> connection to work with this Catalog name. Alternately I was thinking that
> perhaps I could create a Alias name for the Catalog and connect to this
> name. I tried to create a linked Server, but creating the Linked server
> produced the same result as the DTS and I could not connect.
> If possible I would like to find an Alternate to renaming the Database
> Catalog name.
> Regards,
> Bernard.
>
>

How to Create a Catalog Alias

Hello,
I have run into a little problem,
We have a Database Catalog named "Product-V1.0", and I need to create a DTS
package. However when I create the SQL connection and point to the Catalog,
it truncates the Catalog name to "Product-V1" removing the ".0" from the
name. Hence I can't connect. I tried to add [] around the Catalog name
without any effect. So firstly is there a way that I can configure the DTS
connection to work with this Catalog name. Alternately I was thinking that
perhaps I could create a Alias name for the Catalog and connect to this
name. I tried to create a linked Server, but creating the Linked server
produced the same result as the DTS and I could not connect.
If possible I would like to find an Alternate to renaming the Database
Catalog name.
Regards,
Bernard.Hi
You can not create an alias for a DB/catalog.
It is best to follow the standards as described in BOL "Using Identifiers".
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bernard Sircelj" wrote:

> Hello,
> I have run into a little problem,
> We have a Database Catalog named "Product-V1.0", and I need to create a DT
S
> package. However when I create the SQL connection and point to the Catalog
,
> it truncates the Catalog name to "Product-V1" removing the ".0" from the
> name. Hence I can't connect. I tried to add [] around the Catalog name
> without any effect. So firstly is there a way that I can configure the DTS
> connection to work with this Catalog name. Alternately I was thinking that
> perhaps I could create a Alias name for the Catalog and connect to this
> name. I tried to create a linked Server, but creating the Linked server
> produced the same result as the DTS and I could not connect.
> If possible I would like to find an Alternate to renaming the Database
> Catalog name.
> Regards,
> Bernard.
>
>