|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Unable to get data in sql 2005 ok in sql 2000happy Holidays to you all. I developed a windows application that connects to Sql server 2000, using windows authentication and it works, able to retrive and other data process. But when I used it on Sql Server 2005 Express, it was unable to retrive data. What is wrong with it? How can I fixed this? Connecting String at 2000: "integrated security=SSPI;data source=localhost;persist security info=False;initial catalog=Genesis;" Connection String at 2005: "integrated security=SSPI;data source=RITS-DENNIS\SQLEXPRESS;persist security info=False;initial catalog=Genesis;" "user id=guest;password=guest123;data source=RITS-DENNIS\SQLEXPRESS;persist security info=False;initial catalog=Genesis;" Thanks in Advanced. den2005 -- MCP Year 2005, Philippines Hi,
but what is the error message? you can't connect to the database at all? have you configured it to allow network access? its done via 'Surface Area Configuration' utility. Someone sait that you might have to enable Browser service Peter Thanks for reply, Peter.
I tested and able to connect but no records is retrived. What do you mean via 'Surface Area Configuration'? What is that? I would try to start the Browser service. Can this Browser service be activated inside the codes (.Net)? Dennis -- Show quoteMCP Year 2005, Philippines "Rogas69" wrote: > Hi, > but what is the error message? you can't connect to the database at all? > have you configured it to allow network access? its done via 'Surface Area > Configuration' utility. Someone sait that you might have to enable Browser > service > > Peter > > > Hi,
The SAC is in Configuration Tools subfolder in Microsoft SQL Servero 2005 folder in Programs menu on your machine. By default SQL Server 2k5 denies network access to itself. Also, when you are using '.' or '(local)' syntax for server in connection string, SQL Server uses by default named pipes, otherwise it may try to run TCP/IP. But tell me what exception do you catch? Timeout? Acces denied? Peter Usually, I've seen that the TCP/IP protocol is disabled by default. You can
enable it by using the SQL Server Configuration Manager tool. Also, note that by default local connections are allowed. If you need remote connections to SQL Server 2005, you will also need to enable that using the SAC tool. -- Show quoteHTH, SriSamp Email: sris***@gmail.com Blog: http://blogs.sqlxml.org/srinivassampath URL: http://www32.brinkster.com/srisamp "den 2005" <den2***@discussions.microsoft.com> wrote in message news:AD4A8CC8-EB8F-4673-99E2-FE5F51A283AD@microsoft.com... > Hi everybody, > happy Holidays to you all. I developed a windows application that > connects to Sql server 2000, using windows authentication and it works, > able > to retrive and other data process. But when I used it on Sql Server 2005 > Express, it was unable to retrive data. What is wrong with it? How can I > fixed this? > > Connecting String at 2000: > > "integrated security=SSPI;data source=localhost;persist security > info=False;initial > > catalog=Genesis;" > > Connection String at 2005: > > "integrated security=SSPI;data source=RITS-DENNIS\SQLEXPRESS;persist > security > > info=False;initial catalog=Genesis;" > > "user id=guest;password=guest123;data > source=RITS-DENNIS\SQLEXPRESS;persist > security info=False;initial catalog=Genesis;" > > > Thanks in Advanced. > > den2005 > -- > MCP Year 2005, Philippines Thanks for reply, SriSamp.
Why TCP/IP protocol is needed? The database and the application will be on same machine. SAC tool? What is that? Dennis -- Show quoteMCP Year 2005, Philippines "SriSamp" wrote: > Usually, I've seen that the TCP/IP protocol is disabled by default. You can > enable it by using the SQL Server Configuration Manager tool. Also, note > that by default local connections are allowed. If you need remote > connections to SQL Server 2005, you will also need to enable that using the > SAC tool. > -- > HTH, > SriSamp > Email: sris***@gmail.com > Blog: http://blogs.sqlxml.org/srinivassampath > URL: http://www32.brinkster.com/srisamp > > "den 2005" <den2***@discussions.microsoft.com> wrote in message > news:AD4A8CC8-EB8F-4673-99E2-FE5F51A283AD@microsoft.com... > > Hi everybody, > > happy Holidays to you all. I developed a windows application that > > connects to Sql server 2000, using windows authentication and it works, > > able > > to retrive and other data process. But when I used it on Sql Server 2005 > > Express, it was unable to retrive data. What is wrong with it? How can I > > fixed this? > > > > Connecting String at 2000: > > > > "integrated security=SSPI;data source=localhost;persist security > > info=False;initial > > > > catalog=Genesis;" > > > > Connection String at 2005: > > > > "integrated security=SSPI;data source=RITS-DENNIS\SQLEXPRESS;persist > > security > > > > info=False;initial catalog=Genesis;" > > > > "user id=guest;password=guest123;data > > source=RITS-DENNIS\SQLEXPRESS;persist > > security info=False;initial catalog=Genesis;" > > > > > > Thanks in Advanced. > > > > den2005 > > -- > > MCP Year 2005, Philippines > > > Is there any difference if I used windows authentication or any user to
enter data values to a table otehr than 'sa' account, and this data can be viewed and change using any authenticated account? dennis -- Show quoteMCP Year 2005, Philippines "den 2005" wrote: > Thanks for reply, SriSamp. > > Why TCP/IP protocol is needed? The database and the application will be on > same machine. SAC tool? What is that? > > Dennis > > -- > MCP Year 2005, Philippines > > > "SriSamp" wrote: > > > Usually, I've seen that the TCP/IP protocol is disabled by default. You can > > enable it by using the SQL Server Configuration Manager tool. Also, note > > that by default local connections are allowed. If you need remote > > connections to SQL Server 2005, you will also need to enable that using the > > SAC tool. > > -- > > HTH, > > SriSamp > > Email: sris***@gmail.com > > Blog: http://blogs.sqlxml.org/srinivassampath > > URL: http://www32.brinkster.com/srisamp > > > > "den 2005" <den2***@discussions.microsoft.com> wrote in message > > news:AD4A8CC8-EB8F-4673-99E2-FE5F51A283AD@microsoft.com... > > > Hi everybody, > > > happy Holidays to you all. I developed a windows application that > > > connects to Sql server 2000, using windows authentication and it works, > > > able > > > to retrive and other data process. But when I used it on Sql Server 2005 > > > Express, it was unable to retrive data. What is wrong with it? How can I > > > fixed this? > > > > > > Connecting String at 2000: > > > > > > "integrated security=SSPI;data source=localhost;persist security > > > info=False;initial > > > > > > catalog=Genesis;" > > > > > > Connection String at 2005: > > > > > > "integrated security=SSPI;data source=RITS-DENNIS\SQLEXPRESS;persist > > > security > > > > > > info=False;initial catalog=Genesis;" > > > > > > "user id=guest;password=guest123;data > > > source=RITS-DENNIS\SQLEXPRESS;persist > > > security info=False;initial catalog=Genesis;" > > > > > > > > > Thanks in Advanced. > > > > > > den2005 > > > -- > > > MCP Year 2005, Philippines > > > > > >  |
|||||||||||||||||||||||
Other interesting topics