cannot display chinese

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as '.
My website connect to MS SQL Server 2005 and all the chinese data are
displayed as '.
I try to fix the problem for several days, but still can't fix it. Please
help me to solve this problem.
here is the detail of my system.
* SQL Server 2005 via TCP/IP
* the connection string is "Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
Source=xx.xx.xx.xx;Password=xx;"Hi
A client displaying ?'s is when it can't interpret the character value,
therefore look at things like the codepage or Locale settings for the page
etc.
This may help:
http://databases.aspfaq.com/general/can-i-fix-this-mm/dd/yyyy-dd/mm/yyyy-confusion-once-and-for-all.html
John
"HK newsgroup" wrote:
> I cannot display Chinses at ASP page. All chinese data (whatever is
> Traditional or Simply Chinese) are displayed as '.
> My website connect to MS SQL Server 2005 and all the chinese data are
> displayed as '.
> I try to fix the problem for several days, but still can't fix it. Please
> help me to solve this problem.
> here is the detail of my system.
> * SQL Server 2005 via TCP/IP
> * the connection string is "Provider=SQLOLEDB.1;Persist Security
> Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
> Source=xx.xx.xx.xx;Password=xx;"
>
>

Cannot create user on Report Server 2005

Hi, we installed SQL Server 2005 & Reporting Services on a box that had been
running 2000.
I launched the reports website.
When I try to do New System Role Assignment, I type in a domain user and
select a role and click OK, nothing at all happens. No error message, no
response, nothing.
Does anyone have any idea what might be going on?What I tend to do is create a local group and add my domain users to the
local group. Two things to try. Did you put the domain in front of the user?
I.e. MyDomain\Username
Second, are you in the local administrators group. Perhaps you don't have
rights to be doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RebeccaTS" <RebeccaTS@.discussions.microsoft.com> wrote in message
news:730D7944-B019-4E7A-8B9C-EA7EEB33486A@.microsoft.com...
> Hi, we installed SQL Server 2005 & Reporting Services on a box that had
> been
> running 2000.
> I launched the reports website.
> When I try to do New System Role Assignment, I type in a domain user and
> select a role and click OK, nothing at all happens. No error message, no
> response, nothing.
> Does anyone have any idea what might be going on?

Cannot connect to the configuration database.

I am running Windoes 2003 Small Business. When trying to connect to my
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to check
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin Taylor
Martin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]
"Martin Taylor" wrote:

> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to check
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here.
> Martin Taylor
|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those two
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropriate
> answer at the bottom]
>
> "Martin Taylor" wrote:
|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOINT
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter>)
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

Cannot connect to the configuration database.

I am running Windoes 2003 Small Business. When trying to connect to my
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to chec
k
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin TaylorMartin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
--
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]
"Martin Taylor" wrote:

> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to ch
eck
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here
.
> Martin Taylor|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those tw
o
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropr
iate
> answer at the bottom]
>
> "Martin Taylor" wrote:
>|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
>|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOIN
T
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES
.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
>|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter> )
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]