Access to MSSQLServer 2008 R2 but not rights

[Arjay]

If you can still programmatically connect to MyServerName\SQLEXPRESS, but don't see it in SQL mgmt studio, try enter MyServerName\SQLEXPRESS directly instead of attempting to select it from the drop down list.

[pschulz]

why you believe so hardly its about how to connect?

[Arjay]

why you believe so hardly its about how to connect?

It's pretty hard to tell what your issues are at this point. If you can describe clearly what you are trying to do and what problems you are having, please do so; otherwise, let the thread die.

[son1ane]

its good article that showes sql server run.

            string strCnn = ("data source='" + strServerName + "';integrated security=SSPI");
            SqlConnection server = null;

            try
            {
                server = new SqlConnection(strCnn);
                server.Open();
                return true;
            }

            catch (SqlException ex)
            {
                //ClsMsg.message(ex.Message);
                return false;
            }

            catch (Exception ex)
            {
                //throw new Exception(ex.Message);
                return false;
            }

            finally
            {
                server.Close();
                if (server is IDisposable)
                {
                    (server as IDisposable).Dispose();
                }

                if ((server != null))
                    server = null;
            }

[pschulz]

I would change "finally" like:

finally
            {               
               if ((server != null))
                 {  server.Close();
                    if (server is IDisposable)
                    {
                    (server as IDisposable).Dispose();
                 }
                    server = null;
               }

but, it takes down the start subject